Newbetuts
.
New posts in sql-server-2005
Compare dates in T-SQL, ignoring the time part
sql
sql-server
sql-server-2005
tsql
Implementing a naming standard for keys, indexes, constraints
sql-server
sql-server-2008
sql-server-2005
Row_Number() with union query
sql-server-2005
How to list out all Foreign Keys with "WITH NOCHECK" in SQL Server
sql-server
sql-server-2005
foreign-keys
system
Linking ALL Users to Login after restoring a SQL Server 2005 database
sql-server
tsql
sql-server-2005
A way to check if foreign key exists in SQL 2005
sql
sql-server-2005
foreign-keys
Foreign key referencing a 2 columns primary key in SQL Server
sql
sql-server-2005
foreign-key-relationship
Set a existing column of MS SQL table as NOT NULL
sql-server
sql-server-2005
SQL Server Developer Edition versus SQL Server Standard
sql-server
sql-server-2005
sql-server-2008
database
development
What are row, page and table locks? And when they are acquired?
sql-server
sql-server-2008
tsql
sql-server-2005
If logs are being truncated, why use Full recovery?
sql-server
sql-server-2005
Shrink SQL Server data file, but not all at once?
sql-server
sql-server-2005
database-administration
shrink
SQL Server "AFTER INSERT" trigger doesn't see the just-inserted row
sql-server
sql-server-2005
triggers
How can I do the equivalent of "SHOW TABLES" in T-SQL?
sql
tsql
sql-server-2005
Drop all databases from server
sql
sql-server
sql-server-2005
Get top first record from duplicate records having no unique identity
sql
sql-server-2005
tsql
No idea how to handle an error while calling substring on a sql variable
sql-server-2005
stored-procedures
error-handling
Which is better: Bookmark/Key Lookup or Index Scan
sql
sql-server
sql-server-2005
tsql
optimization
Creating a named pipe on Windows
windows
sql-server
sql-server-2005
pipe
Extracting a SQLCLR assembly
sql-server-2005
sqlclr
Prev
Next