Presentation Materials “A Function is a Function”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...
2013-02-28
1,275 reads
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...
2013-02-28
1,275 reads
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-25
1,000 reads
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could...
2013-02-25
648 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
907 reads
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of...
2013-02-21
561 reads
Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files? Until a couple months...
2013-02-21 (first published: 2013-02-13)
2,515 reads
Have you ever had to calculate bitmasks on the fly? I have and still do. In this post, I’m going to show...
2013-02-19
1,649 reads
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-18
589 reads
Ever have your SQL Server slow down for reasons that you can’t explain? Or did you spend all night tuning...
2013-02-18
571 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-15
886 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;