Viewing 15 posts - 35,776 through 35,790 (of 49,558 total)
DBTeam (11/17/2009)
how long it will take to drop it..
How long is a piece of string?
There's no simple answer. Depends on the size of the table (in MB), the other activity,...
November 18, 2009 at 12:26 am
On 2008 Enterprise you can look at Change Tracking, Change Data Capture and SQL Audit. Haven't actually worked with any of them, so can't really give you an opinion. Play...
November 18, 2009 at 12:23 am
1b. Probably, but why would you want to use MAX? Jason posted showing a couple of queries for getting the row counts from sys.partitions.
2. Don't understand the question. Order of...
November 18, 2009 at 12:18 am
cos_ta393 (11/17/2009)
My hope is that sql server has it in system table / views that I can just query.
It doesn't. If you want to know how many rows have...
November 17, 2009 at 12:49 pm
Very strange. Not sure what's happening there.
November 17, 2009 at 12:38 pm
John Burgess-239089 (11/17/2009)
I found a script on a forum that will update the collationid in syscolumns but it is a backdoor method so I will not post it here.
I would...
November 17, 2009 at 12:37 pm
All changes to a database are logged (including schema changes). Since log shipping takes the log backups (which contain all the changes) and restores them on the secondary, all changes...
November 17, 2009 at 12:32 pm
Are they all part of the same database? The error says that you've got some files from one database, some files from a different database and you're trying to attach...
November 17, 2009 at 12:31 pm
lovesky202005 (11/17/2009)
So, I just thought this would be the right place to ask SQL doubts although the problem is with MySQL.
This is a Microsoft SQL Server forum. You might get...
November 17, 2009 at 12:28 pm
Lynn Pettis (11/17/2009)
ARRRRGGGGGG!!!!
Anything in particular?
November 17, 2009 at 12:25 pm
Bru Medishetty (11/17/2009)
Resource Governor a new feature in SQL 2008 can give a similar...
November 17, 2009 at 12:23 pm
subs99 (11/17/2009)
But it turns out by making a superJumbo-sized post...
November 17, 2009 at 12:20 pm
Odd. You're absolutely sure this database is in simple recovery?
If you run a manual checkpoint does the log usage drop?
November 17, 2009 at 12:19 pm
DISTINCT TOP 100? If run without distinct does it really return duplicates? If so, why are there duplicates? If not, remove that distinct, it's expensive.
November 17, 2009 at 8:25 am
Viewing 15 posts - 35,776 through 35,790 (of 49,558 total)