Viewing 15 posts - 46,681 through 46,695 (of 49,571 total)
It does work for auto grow and shrink, also cleans up dropped objects or indexes.
Done anything like that recently?
May 7, 2008 at 2:24 pm
What tends to cause massive fragmentation on the disk level is repeated shrinks and grows of the data file, especially if there are multiple data files on the same disk...
May 7, 2008 at 2:08 pm
No need for begin tran. The trigger runs within the transaction started by the insert/update
May 7, 2008 at 2:00 pm
In this case yes. That's assigning the results of a subquery to a variable. and only works with a single variable and column.
May 7, 2008 at 1:36 pm
AVB (5/7/2008)
If an Insert occurs I'm not...
May 7, 2008 at 1:30 pm
Depends what it is. The database backend for my blog and personal web site. Hosted. The databases for a major bank. Own data center with own staff.
If you're hosting, make...
May 7, 2008 at 12:38 pm
Hints in general should be avoided unless you really know what you're doing and have a very, very good reason to use them.
Badly applied locking hints can cause major problems....
May 7, 2008 at 12:14 pm
The top's in the wrong place
SELECT TOP 1 @ID = OrderVal FROM qryCust
WHERE OrderNo = '000663' AND DiscountGroup = 'XXND' AND CustID = 3
May 7, 2008 at 2:06 am
Views are just saved select statements. UDFs, especially the multi-statement table valued function, can have complex logic, conditional statements, loops, etc
At time of execution, the defnition of a view it...
May 7, 2008 at 1:10 am
User databases or system databases?
User databases are easy. Detach, copy the files, reattach. The system ones are a lot more tricky and the method is different for each one.
There's probably...
May 7, 2008 at 12:56 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to the following
http://www.sqlservercentral.com/Forums/Topic496050-147-1.aspx
May 7, 2008 at 12:13 am
Should be possible, though I've never tried.
The hex value given (9701bf0d0dea) is a hash of the index keys. If you know what hashing algorithm is used to generate that (maybe...
May 7, 2008 at 12:11 am
Can you change the password? Not perfect, but should suffice.
May 6, 2008 at 3:22 pm
Looks like a partition ID. Your KB article is SQL 7/2000
Try querying sys.partitions where partition_ID = 72057594386382848
You should be able to get the objectID and index ID from that
May 6, 2008 at 3:22 pm
Do not update the system tables. It can have nasty side effects and is extremely risky.
Windows or SQL login?
May 6, 2008 at 2:39 pm
Viewing 15 posts - 46,681 through 46,695 (of 49,571 total)