Viewing 15 posts - 7,021 through 7,035 (of 22,219 total)
I think everyone else largely has it covered between data types and the possibility of encryption, you may see little to no compression.
"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 5, 2015 at 8:07 am
IncidentalProgrammer (1/5/2015)
Grant Fritchey (12/30/2014)
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
January 5, 2015 at 6:32 am
To my knowledge, no, you can't do this. The instance is exposed as a single IP, especially across the cluster. I've never seen anyone set up different IP addresses for...
"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 5, 2015 at 6:28 am
Here's the entry in the Books Online for DROP STATISTICS.
I strongly recommend just keeping a link to the Books Online. That's where you'll need to go for most of your...
"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 5, 2015 at 6:24 am
IncidentalProgrammer (1/5/2015)
GilaMonster (12/30/2014)
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
January 5, 2015 at 6:18 am
Ha! No, no thanks.
I'm sure your install can be saved. I have yet to see one that couldn't be cleaned up in some fashion. You just have to 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
January 5, 2015 at 4:14 am
You can set up SQL Server on a different machine (hosted or not). In order to use it for your development, you just need to make sure you set 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
January 4, 2015 at 4:04 am
Lynn Pettis (1/3/2015)
Jeff Moden (1/3/2015)
http://www.sqlservercentral.com/Forums/Topic1648047-2799-1.aspx
Anyone have even a...
"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 4:00 am
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
Viewing 15 posts - 7,021 through 7,035 (of 22,219 total)