Can we add multiple CONSTRAINTs on a single column in a table?

Posted by Sqltimes
On October 28, 2012
0 Comments

Yes, it is allowed to add multiple column level CONSTRAINTs to the same column in a table. All the CONSTRAINTs are checked for every INSERT, UPDATE operation and all must be satisfied for the INSERT/UPDATE operation to be successful. Following is an example (DBA.SampleTable) with a column (Col2) with 3 constraints. Default: DF_SampleTable_ID Foreign Key : […]

Posted by Sqltimes
On October 21, 2012
0 Comments

When you are executing long running queries or executing a long batch, sometime, you want to send some quick responses back to the client (i.e. Management Studio [SSMS], etc.) to show the progress. Usually I add PRINT statements at every block of statements to show the progress made from one block of statements to the […]

Posted by Sqltimes
On October 16, 2012
0 Comments

“Performance Studio” is a new tool available natively starting Sql Server 2008. In Sql Server 2005 days, we had a tool (plugin) called “Performance Dashboard” (SP2 and later only) that relies on DMV & DMF to show the performance statistics of Sql Server almost real time. Its reports would query the DMV’s real time and […]

Posted by Sqltimes
On October 15, 2012
0 Comments

A few days ago, I was setting up Change Data Capture (CDC) on a new database on my machine and I ran into this error. [sourcecode language=”sql”] Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186 Could not update the metadata that indicates database ‘MyDB’ is enabled for Change Data Capture. The failure occurred […]

Posted by Sqltimes
On October 14, 2012
0 Comments

This is a quick post to show some details on this undocumented stored procedure used to delete older backup files. Parameters for this stored procedure are not documented in BoL or not readily available, may be for a good reason. But I wanted to add some details to shed some light. [sourcecode language=”sql”] EXECUTE master.dbo.xp_delete_file […]

Posted by Sqltimes
On October 14, 2012
0 Comments

This is an interesting error that I ran into recently. After some research and gathering useful information I stumbled up on this link from one of the Microsoft folks. This helped me appreciate the error message a bit more. Login failures are common. We see them everyday (hopefully not on production machines). But the error […]

Can we add multiple CONSTRAINTs on a single column in a table?

Sql Server: How to notify client about progress made using frequent PRINT statements.

Performance Studio – New monitoring tool in Sql Server 2008

Error while configuring Change Data Capture (CDC) on Sql Server 2008

EXECUTE master.dbo.xp_delete_file in Sql Server 2008

Login failed for user ”. (Microsoft SQL Server, Error: 18456) in Sql Server 2008