Call for Nominations – PASS Board of Directors
Sometime in the next couple weeks will mark the beginning of the 30 day period where we accept nominations for the...
2009-07-26
996 reads
Sometime in the next couple weeks will mark the beginning of the 30 day period where we accept nominations for the...
2009-07-26
996 reads
Steve Lane and team from Tallahassee are hosting their annual Code Camp on Sep 5, 2009, and have asked if...
2009-07-26
656 reads
Stuart Ainsworth is launching SQLSaturday #24 & #25, both in Gainesville, GA on October 9th and 10th respectively, and yes, one...
2009-07-24
635 reads
Found The Candy Bombers: The Untold Story of the Berlin Airlift and America's Finest Hour by Andrei Cherny ($20 @ Amazon) ...
2009-07-23
537 reads
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
2009-07-23
5,029 reads
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
719 reads
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
704 reads
Understanding referential integrity is important for anyone working with databases. It can help you design better forming systems. Learn the basics of foreign keys in this SQL School video.
2009-07-21
8,607 reads
Time for another update on all things PASS. I’ve been struggling to find time for PASS activities and having to...
2009-07-21
596 reads
I bet most of you have at least one customer loyalty card in your wallet or on your keyring, one...
2009-07-20
716 reads
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...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
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;