Viewing 15 posts - 19,201 through 19,215 (of 22,226 total)
I'm still a bit confused by the question.
By and large, understanding what's occurring at lower levels within the system is useful, but shouldn't be a day-to-day worry. Rather than be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 8:13 am
Because, right now, I'm utterly confused what storing an IP address has to do with "auto locking" which is the title of the post.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 7:45 am
Is this 2005?
If so... GOTO? Oooh, yuck. 😉
Using TRY/CATCH you can then do as Gail suggested and fire off RAISERROR which will automatically move you into the CATCH statement. Much...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 5:58 am
rajesh_281984 (12/3/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 5:53 am
We mostly use schemas for storage requirements or security, but I don't think simple organization would be an issue either. I also agree with Jack, if you have to combine...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 5:46 am
It's much easier to answer questions on the forum if you provide a very clear, focused and detailed question. Really general and vague questions can only be answered in general...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 5:40 am
Another word of caution for the DTA. I recently ran a series of experiments using the DTA against AdventureWorks2008. It wasn't capturing obvious indexing issues. I don't trust it at...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 5:28 am
skjoldtc (12/2/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2008 at 5:25 am
One minor detail in addition, run update statistics will full scan.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2008 at 1:34 pm
If you're simply manipulating data, no, system tables aren't affected... well, OK, changing data can change statistics, so where the statistics are maintained can be changed, and if you have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2008 at 12:34 pm
Mike Levan (12/2/2008)
some thing like this.
IF @frag < 30.0
...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2008 at 10:46 am
"You don't know the power of the database"
Oh boy, we can have fun with this one...
"Don't fail me a again, programmer"
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2008 at 10:37 am
Whether or not to use varchar or nvarchar really depends on the type of data you're storing. If you are not now or ever going to store different character sets...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2008 at 10:35 am
Clarification: "Column aliases in ORDER BY clause cannot be prefixed by table alias"
Sorry. What I said earlier was misleading. Also, on rereading, I'm not shocked that this doesn't work. I'm...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2008 at 10:32 am
Darth Vader is better than Leather-face, which was what I came close to.
"I find your lack of indexes disturbing..."
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2008 at 10:28 am
Viewing 15 posts - 19,201 through 19,215 (of 22,226 total)