Viewing 15 posts - 5,041 through 5,055 (of 22,224 total)
RonKyle (3/3/2016)
But if you keep this in one table you lose a lot of data integrity control from the database side. You now have to allow null and move the...
"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
March 3, 2016 at 11:36 am
I'm with Sean. I would absolutely normalize this data. There are simply tons and tons of reasons why. Let's start with the simplest, ensuring that every single spelling of the...
"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
March 3, 2016 at 11:34 am
If all you want is the structure, here's another vote for using the DACPAC. However, I'm with Steve (on multiple levels, I work with him), that if you need to...
"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
March 3, 2016 at 11:27 am
Best approach would to create a backup file using the BACKUP command, and then restore that to another location. From there, do whatever you want, but start with the backup....
"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
March 3, 2016 at 11:24 am
Without seeing the execution plan to understand how the optimizer is resolving the query, it's really hard to know. It's possible that it chose a Nested Loops when a Hash...
"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
March 3, 2016 at 11:21 am
Jeff Moden (3/3/2016)
Grant Fritchey (3/3/2016)
Jeff Moden (3/2/2016)
sickb00000y (3/2/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
March 3, 2016 at 7:23 am
You can't really figure out what the "last" user is without some method of indicating the order of the users. You have to have a date or a sequence number...
"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
March 3, 2016 at 6:36 am
Jeff Moden (3/2/2016)
sickb00000y (3/2/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
March 3, 2016 at 6:31 am
Data is going to grow. You need to be prepared for that. If you want to monitor what's happening on a database, the best tool is extended events. However, you...
"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
March 3, 2016 at 6:30 am
shamshad.ali (3/3/2016)
Can you please let me know how can I test it and share the stats? then we can decided if it is feasible to go ahead?Shamshad
Set up the situation....
"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
March 3, 2016 at 4:21 am
Jeff Moden (3/2/2016)
Considering the recent track record for SPs and CUs, you might consider waiting for at least a month before you deploy either.
Oh yeah, I wouldn't recommend deploying 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
March 2, 2016 at 11:50 am
GilaMonster (3/2/2016)
Grant Fritchey (3/2/2016)
Anycompletedtransactions that are currently in the log are what get backed up.Uncommitted also get backed up.
I always forget that part of how it works....
"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
March 2, 2016 at 9:44 am
The number and frequency of SPs for every new version of SQL Server has been dropping over time. I wouldn't wait on SPs any more but would instead rely on...
"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
March 2, 2016 at 9:00 am
As others have said, the log backup is the easiest one to explain. Any completed transactions that are currently in the log are what get backed up. Those completed transactions...
"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
March 2, 2016 at 8:58 am
The big value will get added to the last page, and then everything else will be inserted behind it. Without testing I couldn't see just to what degree having 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
March 2, 2016 at 6:39 am
Viewing 15 posts - 5,041 through 5,055 (of 22,224 total)