Viewing 15 posts - 7,036 through 7,050 (of 22,226 total)
Wild guess...
Do you mean a table that will be automatically created in each database? Then create it first in the model database on your system.
"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
January 4, 2015 at 3:59 am
Speaking for myself, it was stability that kept me in one place for a long time. I didn't love the company, but it was fundamentally fair and treated me fine....
"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
January 3, 2015 at 5:18 am
It's not something I've tried, but I suspect it won't work. Go through all the limitations currently in force on tables that can go into memory and I'm pretty...
"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
January 3, 2015 at 5:06 am
Jeff Moden (1/2/2015)
Stefan Krzywicki (1/2/2015)
Happy New Year everyone!Who, like me, is at work today?
Me. Covering for the younger folks that have families.
I'm working today. Just finished a new article...
"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
January 2, 2015 at 8:44 am
For a production database, your best bet to protect the database is backups.
"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
January 2, 2015 at 4:18 am
MMartin1 (12/29/2014)
Out of curiosity, any performance considerations with logon triggers that you are aware of?
Just like any other trigger, it depends on what you're doing with it. There's...
"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
January 2, 2015 at 4:16 am
Welsh Corgi (12/31/2014)
drottdog (12/31/2014)
If your server is a Virtual Machine perhaps a VM Snapshot would be useful.Right on. That is what I wanted but I do not have permissions...
Thanks.
Then...
"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
January 2, 2015 at 4:14 am
spaghettidba (1/1/2015)
And there's a very special thank you message for every single one of you on my blog here! 🙂
Thank you for involving me in the most...
"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
January 2, 2015 at 4:05 am
IncidentalProgrammer (12/29/2014)
"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 30, 2014 at 3:55 am
Welcome to the forums!
Best of luck on what you're trying to accomplish.
The one thing I would add is to be sure that you learn how SQL Server does backups. It's...
"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 27, 2014 at 5:26 am
Lynn Pettis (12/23/2014)
"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 27, 2014 at 5:21 am
burfos (12/22/2014)
Could a database audit specification be another solution?
Sure, but audit compared to what? You have to maintain some sort of baseline. That's one of the many resources that having...
"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 27, 2014 at 5:16 am
Nope. You can't do that within the definition of a procedure. So, instead, you can use a local variable and set that within the body of the procedure.
"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 19, 2014 at 5:50 am
Pretty sure it will connect, yes. But, you will be better off in terms of support with the upgraded client.
"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 19, 2014 at 3:28 am
It's probably the same plan, but there will be two of them because you have what would be considered two different queries because of the different aliases.
"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 19, 2014 at 3:25 am
Viewing 15 posts - 7,036 through 7,050 (of 22,226 total)