Viewing 15 posts - 7,021 through 7,035 (of 22,226 total)
Oh no, this is absolutely not the place for a trigger. The right answer is to make those columns not null. That will raise an error and that error 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
January 6, 2015 at 5:04 am
WayneS (1/5/2015)
Grant Fritchey (1/4/2015)
Lynn Pettis (1/3/2015)
Jeff Moden (1/3/2015)
http://www.sqlservercentral.com/Forums/Topic1648047-2799-1.aspx
Anyone...
"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:12 pm
KenpoDBA (1/5/2015)
I think you guys have all been punked.
Oh noes. Not again.
Ha!
"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:11 pm
Another thing to check are the ANSI settings for the connections. Maybe one set of machines is different than the others. That can lead to differences in execution plans and...
"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:08 pm
If it's only a few tables, you could try just using a MERGE query to make it so that the data is moved across based on what's new, deleted or...
"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:06 pm
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
Viewing 15 posts - 7,021 through 7,035 (of 22,226 total)