Viewing 15 posts - 4,276 through 4,290 (of 22,219 total)
Just curious, what about the right hand side? You can write a query that puts a function against a column on either side of the operand and it will behave...
"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
November 2, 2016 at 5:33 am
Hugo Kornelis (11/1/2016)
BWFC (11/1/2016)
I've got a barrel of cider maturing in the cellar, can I come?Just send the barrel. We'll review your application later. :Whistling:
SECOND!
All in favor?
"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
November 1, 2016 at 5:50 am
Bill Talada (10/31/2016)
"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
October 31, 2016 at 12:33 pm
Here's a blog post [/url]from Microsoft on how to do this if you're not using AD. It's a little old, but the process is the same. You'll need to connect...
"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
October 31, 2016 at 7:48 am
As long as the checklists are for things we can't automate. I've seen many peoples checklists and thought, why don't you just automate the first six items.
"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
October 31, 2016 at 7:46 am
Jeff Moden (10/31/2016)
[font="Arial Black"]<sarcasm ON> [/font]everyone knows that it's the database that's the problem [font="Arial Black"]<sarcasm OFF>[/font], right?
Not at my old company. They actually had a running joke that...
"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
October 31, 2016 at 7:17 am
Sean Redmond (10/31/2016)
"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
October 31, 2016 at 7:13 am
Iwas Bornready (10/25/2016)
I still hope I never have to see either apocalypse.
Agreed, but especially the clown 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
October 25, 2016 at 7:32 am
Another vote for that fine book.
I'm also going to pile on and say that you need to ensure your backups are in place. More than that, you need to ensure...
"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
October 21, 2016 at 11:12 am
sqlfriends (10/21/2016)
"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
October 21, 2016 at 10:36 am
sqlfriends (10/21/2016)
Grant Fritchey (10/21/2016)
"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
October 21, 2016 at 10:32 am
Steve Thompson-454462 (10/21/2016)
Hope you pardon the shameless plug, but we're using the Red-gate tools to facilitate this; they've been great!
I don't pardon the shameless plug. I actively encourage it! Ha!
Good...
"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
October 21, 2016 at 9:11 am
No idea why someone would use two databases in this fashion unless the filestream was added as an afterthought and they just didn't want to modify the existing database.
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
October 21, 2016 at 6:08 am
lindsayscott23 (10/21/2016)
"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
October 21, 2016 at 5:51 am
Brandie Tarvin (10/20/2016)
I think you misunderstand what Grant meant by cross-database querying.
If you separate out the data into individual databases, how many queries will have to touch these multiple databases...
"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
October 20, 2016 at 9:41 am
Viewing 15 posts - 4,276 through 4,290 (of 22,219 total)