Viewing 15 posts - 8,086 through 8,100 (of 22,214 total)
TheSQLGuru (5/20/2014)
Grant Fritchey (5/20/2014)
May 20, 2014 at 1:21 pm
lkennedy76 (5/20/2014)
nimalatissa (5/19/2014)
May 20, 2014 at 1:20 pm
Lynn Pettis (5/20/2014)
vasugunda (5/20/2014)
in between 200 to 250 usdvasugunda (5/20/2014)
no per monthThat would work out to about 2 hours of assistance each month.
Consultants aren't cheap.
You need to charge more. That's...
May 20, 2014 at 1:18 pm
muthyala_51 (5/20/2014)
As once the database has been migrated to 2014- can i take the backup of 2014 database and restore to 2008?
No. You can never restore a database down in...
May 20, 2014 at 1:15 pm
yuvipoy (5/20/2014)
GilaMonster (5/20/2014)
No, the fragmentation will be the same, both are having NEWID() specified as the value so the default is being overridden.
No Gail
I checked it ...there is less frag...
May 20, 2014 at 4:31 am
Chances are you didn't run the restore with the syntax KEEP_CDC. In this event, even though, as Kevin says, the backup includes the CDC tables and data, they're removed during...
May 20, 2014 at 4:26 am
You'll have to let the identity values be regenerated by the system that you're moving everything into. You can capture the new values using the OUTPUT clause. With that you...
May 20, 2014 at 4:22 am
If you have lost the database or it's been corrupted and you don't have a backup available, you'll have to rebuild the database. Microsoft has documentation on how to do...
May 20, 2014 at 4:15 am
Why doesn't backup work?
Because my other suggestion is mirroring and that requires a backup and restore as well.
May 19, 2014 at 3:37 pm
Koen Verbeeck (5/19/2014)
Grant Fritchey (5/19/2014)
May 19, 2014 at 7:50 am
free_mascot (5/19/2014)
If you have doubt and server is not production you can enable trace for the specific database and check the activities going on?
You can trace production too, surely. Just...
May 19, 2014 at 7:39 am
If you're upgrading because of concerns about the general age of the software, then you should just upgrade to the latest version. There shouldn't be any discussion. But, any other...
May 19, 2014 at 7:38 am
Security has frequently been a problem in SSDT. My recommendation would be to use the post-deployment scripts. That way you can break it down as needed, but still have it...
May 19, 2014 at 7:34 am
I usually just refer to row and column. They may not be 100% ISO approved terms, but, everyone knows what you're referring to for the most part. And if we're...
May 19, 2014 at 7:32 am
Viewing 15 posts - 8,086 through 8,100 (of 22,214 total)