Viewing 15 posts - 5,116 through 5,130 (of 6,022 total)
Christopher Reed (5/31/2012)
Steve,I'm just curious. What was "c"? You never listed it in the editorial.
I was just about to post the same question.
Based on the logical...
June 1, 2012 at 7:44 am
I've actually never leveraged sp_getapplock nor even encountered it, and I've seen a lot of databases code. However, I have seen situations where developers have implemented their own concurrent "locking"...
May 25, 2012 at 2:58 pm
It's rare that I'll see a truly great science fiction film. What I'm talking about is a film that's a great adaptation of a great sci-fi novel. Most of the...
May 25, 2012 at 7:23 am
allmhuran (5/10/2012)
...
COMMAND LINE BASE SOLUTIONS
OPTION: output to text file using bcp/sqlcmd
ISSUES: prone to special character problems, like tabs, commas, newlines etc embedded in large text coulumns such as memos,...
May 25, 2012 at 6:33 am
A couple of weeks back, I went to see "Mirror, Mirror" with my wife and kids. I went into it with only luke warm expectations, but it actually turned out...
May 25, 2012 at 6:01 am
My first guess is that it would be the result of index fragmentation or page splits.
SQL Server Fragmentation The Basics
http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-1-the-basics/
Also, you may want to consider moving your LOB...
May 22, 2012 at 8:28 am
How to troubleshoot a Msg 823 error in SQL Server
http://support.microsoft.com/kb/2015755
To start, SQL Server 2008+ contains a system table called SUSPECT_PAGES that maintains information about suspect pages and their error...
May 22, 2012 at 7:44 am
Markus (5/16/2012)
May 16, 2012 at 7:05 am
Markus (5/16/2012)
May 16, 2012 at 6:49 am
rafael_si (5/14/2012)
Hello Eric,Since my business key do not duplicate, the identity column is not necessary, is it?
No, it's not necessary. Having LoadDateTime + ID would just be an alternative...
May 14, 2012 at 12:28 pm
Elliott Whitlow (5/10/2012)
Lynn Pettis (5/10/2012)
Anyone tuning the query by not looking at IO and Time statistics and query plan would immediately fail.
Guess I'd fail here. First things I look...
May 10, 2012 at 12:23 pm
Using LoadDate as the leading column in primary clustered key makes sense in a table containing historical rows, because it's sequential (I'm assuming it's based on system date at the...
May 10, 2012 at 11:07 am
When tables and indexes are created, their internal data structure is effected by whatever collation setting was currently in effect. Similar to Fill Factor, I believe that after changing the...
May 10, 2012 at 7:52 am
Personally, I don't own an iPhone, Android device, or whatever. If I did, I'd keep my Hotmail or Gmail account stuff in the cloud and not have it setup to...
May 9, 2012 at 8:32 am
This is a good script.
One suggested addition would be a 'schemaname' column. When I'm unit testing in Development, I often times have a different version of the stored procedure...
May 7, 2012 at 10:38 am
Viewing 15 posts - 5,116 through 5,130 (of 6,022 total)