More posts coming soon...
Haven't been around for a while, but doing some interesting work with Database Refactoring and Effective Dating...more posts coming soon....
2010-03-10
589 reads
Haven't been around for a while, but doing some interesting work with Database Refactoring and Effective Dating...more posts coming soon....
2010-03-10
589 reads
What are the benefits of Effective Dating and what problems does it solve?
2009-10-01
10,058 reads
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL and was having problems. I don’t normally use T-SQL for such heavy string parsing, but this was a special case of a legacy structure that I had to work with, so I had no choice.
2009-08-27
5,504 reads
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL...
2009-08-23
8,654 reads
Ever try to print out a long VARCHAR(MAX)/NVARCHAR(MAX) string, only to find that it's truncated at 8,000/4,000 characters? How do you get around this? New author Sam Bendayan shows us how.
2009-07-29
11,878 reads
OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data...
2009-05-18
3,057 reads
Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job posting only to find that it's not what you do? Or asked for a DBA resume from a recruiter and gotten something other than what you expected? Or...
2009-05-14
1,999 reads
OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store...
2009-05-13
1,611 reads
You will be at least 2 cents richer....
2009-05-12
532 reads
Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job...
2009-05-12
1,182 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;