Viewing 15 posts - 7,021 through 7,035 (of 22,221 total)
The process is outlined pretty clearly here in the Books Online. You need to create a TYPE the defines the table structure and then you can set the parameter 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 5:13 pm
Books Online is always the place to start when learning about anything in SQL Server. When you're ready for the details, I can't recommend Denny Cherry's book on security strongly...
"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 11:23 am
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
Viewing 15 posts - 7,021 through 7,035 (of 22,221 total)