T-SQL Enhancement: THROW
When bulding solid T-SQL solutions, it is often necessary to implement some level of error handling. One of the most...
2011-06-14
1,179 reads
When bulding solid T-SQL solutions, it is often necessary to implement some level of error handling. One of the most...
2011-06-14
1,179 reads
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary...
2011-06-07
537 reads
In the next couple of weeks we’ll do a series of blog posts with some of the T-SQL enhancements that...
2011-06-07
460 reads
On June 1st GITCA will run a 24 hour round-the-world virtual event focusing on Cloud Computing. Please visit http://sp.GITCA.org/sites/24Hours for...
2011-05-31
1,577 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;