SQL Server

Custom alert on the SQL Database

posted @ Saturday, July 04, 2009 7:07 AM | Feedback (0)

Safe Save DateTime to SQL Database.

posted @ Sunday, May 03, 2009 9:13 PM | Feedback (2)

Stored procedure to find the biggest tables in the database

posted @ Saturday, February 28, 2009 5:32 PM | Feedback (0)

Error: "Autogrow of file in database was timed out"

posted @ Sunday, January 18, 2009 11:26 AM | Feedback (0)

SSIS import from Excel to SQL table doesn't like empty lines

posted @ Friday, January 09, 2009 11:55 AM | Feedback (1)

SQl Server Management Studio doesn't show new lines in records.

posted @ Thursday, November 13, 2008 11:55 PM | Feedback (0)

"Login failed for user" may mean "database name is invalid"

posted @ Friday, July 25, 2008 1:53 AM | Feedback (0)

T-SQL not equal WHERE condition excludes records with null values.

posted @ Tuesday, July 15, 2008 11:45 PM | Feedback (4)

View html source in "Reporting Services" Report Design Preview

posted @ Thursday, January 03, 2008 10:51 AM | Feedback (0)

SQL Server Reporting Services Notes

posted @ Sunday, November 25, 2007 7:55 PM | Feedback (0)

SQL Server Seminar presented by Kevin Kline

posted @ Sunday, October 21, 2007 10:02 AM | Feedback (1)

SQL Server Stored Procedure Naming Standard Recommendations

posted @ Thursday, October 04, 2007 1:00 AM | Feedback (1)

T-SQL User defined function to concatenate column to CSV string

posted @ Tuesday, October 02, 2007 3:18 PM | Feedback (11)

"This SqlTransaction has completed; it is no longer usable." errors

posted @ Monday, September 03, 2007 1:08 AM | Feedback (6)

Reference to different database in "Database Mirroring" environment

posted @ Saturday, May 26, 2007 2:54 PM | Feedback (0)

Start Transaction from ASP.Net application can cause unexpected locks on the database.

posted @ Wednesday, May 16, 2007 2:25 AM | Feedback (1)

.Net SQL Parser

posted @ Saturday, August 12, 2006 3:36 PM | Feedback (3)

Use GUID, not IDENTITY as a primary key for tables that are required "merge-like replication”.

posted @ Thursday, August 03, 2006 9:31 AM | Feedback (0)

"default collation" for a SQL Server 2000 database

posted @ Thursday, February 23, 2006 7:35 AM | Feedback (1)

MS Access Project uses incorrect SQL if RecordSource starts with leading space.

posted @ Wednesday, February 22, 2006 8:36 AM | Feedback (0)

Remove NewLine characters from the data in SQL Server

posted @ Tuesday, November 15, 2005 11:08 AM | Feedback (34)

November

Sun

Mon

Tue

Wed

Thu

Fri

Sat

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

1

2

3

4

5

About

Article Categories

Archives

Post Categories

Links

Syndication: