Viewing 15 posts - 5,026 through 5,040 (of 22,211 total)
Lowell's answer is excellent. Just understand the logic he used. He's taking 24 hours off the time. You could also just take one day off the time using the same...
March 3, 2016 at 11:44 am
The account that runs the backup has to have permission to run the backup and it has to have permission on where the backup is going. If you create a...
March 3, 2016 at 11:42 am
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...
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...
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...
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....
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...
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)
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...
March 3, 2016 at 6:36 am
Jeff Moden (3/2/2016)
sickb00000y (3/2/2016)
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...
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....
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...
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....
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...
March 2, 2016 at 9:00 am
Viewing 15 posts - 5,026 through 5,040 (of 22,211 total)