Viewing 15 posts - 9,796 through 9,810 (of 22,219 total)
When I saw "visionary Database Administrator" I would have thrown my hands up and run screaming. That means, "We break all the rules, regularly, sometimes even on purpose, we know...
"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
May 24, 2013 at 3:24 am
GilaMonster (5/22/2013)
Grant Fritchey (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?Will an Arkansas tire thumper work?
No idea what one...
"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
May 23, 2013 at 4:00 am
Steve Jones - SSC Editor (5/22/2013)
Sean Lange (5/22/2013)
Steve Jones - SSC Editor (5/21/2013)
"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
May 22, 2013 at 3:50 pm
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?
Will an Arkansas tire thumper work?
"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
May 22, 2013 at 3:47 pm
subhajeetsur (5/22/2013)
u can use between while joining as said in above post but then it will not be optimized solution as ur query performance will hamper.
In what way? A BETWEEN...
"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
May 22, 2013 at 5:13 am
There's no way to get around space allocation. In order to run the restore process, you must allocate the required space needed for that process. You can use the MOVE...
"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
May 22, 2013 at 4:05 am
Hey Steve, which apps. I'm just curious. I moved to a WP last fall and with one exception, I've found it better than my Droid. The exception is the Swype...
"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
May 22, 2013 at 4:02 am
And after working through Gail's excellent articles, I'd suggest getting a copy of my book. The 2012 one will be mostly applicable to 2008R2.
"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
May 21, 2013 at 8:21 am
Well, OK then. If it's bytes, what do you want to display? Kilobytes is derived by dividing the number of bytes by 1024 because that's how many bytes makes up...
"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
May 21, 2013 at 7:56 am
If you haven't set max memory, then, as has been noted, SQL Server will use all the memory it can. You can set max memory this way. Or, you can...
"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
May 21, 2013 at 7:53 am
To restore the database, you'll have to move everything. No options there. You can shrink it after the restore is complete. Or, you can modify the structure prior to the...
"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
May 21, 2013 at 3:55 am
Lynn Pettis (5/17/2013)
Grant Fritchey (5/17/2013)
Or just turn off intelisense and get a tool that works.
I have had to turn of SQL Prompt here at work as it sometimes fails due...
"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
May 17, 2013 at 11:31 am
I've seen issues with filtering on database name in Trace. My suggestion, switch to database id if you can. If not, the better solution, switch to extended events. They are...
"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
May 17, 2013 at 11:23 am
Or just turn off intelisense and get a tool that works.
"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
May 17, 2013 at 11:21 am
You could simply do the BETWEEN operation in your JOIN criteria within T-SQL, but you're going to have to be careful about your indexing. And, it's not an enforceable join...
"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
May 17, 2013 at 11:17 am
Viewing 15 posts - 9,796 through 9,810 (of 22,219 total)