SQL Server 2011 - Code Name "Denali" & BOL
Many information via Twitter, LinkedIN, forums, blogs, including also here in SSC, have announced about new incmoing version of the...
2010-11-09
880 reads
Many information via Twitter, LinkedIN, forums, blogs, including also here in SSC, have announced about new incmoing version of the...
2010-11-09
880 reads
Just for info that the incoming 24 Hours of PASS now has bonus sessions ...you can check for the details...
2010-09-10
707 reads
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
636 reads
Another free tool for SQL Server that supports SQL Server 2008/2005/2000, comes from xSQL Software, the Script Executor Commnity Edition,...
2010-09-03
1,178 reads
For a long time I haven't been active member at SSC, so I'm coming back again, saying once again Hello...
2010-09-03
604 reads
Getting Started with SQL Azure - Very nice & short document about SQL Azure beginning process. This is the official document that...
2010-07-07
1,283 reads
Using the command prompt for stopping and starting services is a very nice possibility and very fast! We know that...
2010-06-23
17,267 reads
Microsoft, has published things that can be very useful, in this case for the SQL Server users. They announced the...
2010-06-22
3,708 reads
Two of the biggest events in the Technology World will be held at the same date!
PASS SUMMIT 2010 (8-11, November...
2010-06-10
736 reads
On June 9, 2010 is held the annual event that in Prishtina is recognized as Microsoft TechUpdate. Presenters in this...
2010-06-09
1,840 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;