Viewing 15 posts - 38,596 through 38,610 (of 49,571 total)
usman.tanveer (6/8/2009)
but i am getting an error in the second step, when i tried to restore the most recent differential backup i got following error.
That error comes from restoring a...
June 9, 2009 at 2:56 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic731203-146-1.aspx
June 9, 2009 at 2:51 am
San (6/8/2009)
How can we utilise FIRE_TRIGGERS option.?
Fire triggers is a property of the BULK INSERT command and it controls whether or not insert triggers are fired for a bulk insert...
June 9, 2009 at 2:34 am
homebrew01 (6/8/2009)
If we do, is there a way to repair the fragmentation damage that occurs ?
Internal (index) fragmentation or external (file) fragmentation?
For the first, rebuild your...
June 8, 2009 at 2:11 pm
David (6/8/2009)
Basically I'm trying to calculate the Median of a set of values. At the moment the sort order is causing problems because the values are in the wrong order.
If...
June 8, 2009 at 2:08 pm
Just for interest, it's usually recommended that the backup be done to local disks and then copied to the network. Firstly because of the speed of local drives vs the...
June 8, 2009 at 12:58 pm
Just so you know, it is strongly not recommended that SQL run on a NAS. I'll find kb article if you like, or you can search yourself (I'd have to...
June 8, 2009 at 12:55 pm
darth.pathos (6/8/2009)
but was looking for more in-depth (ie. Geeky ;-)) information about them.
Not sure what you're looking for. What's normal for pages/sec depends greatly on the app. A...
June 8, 2009 at 12:24 pm
I'm sure it was. Don't recall where it's set though.
June 8, 2009 at 12:13 pm
SuzDBA (6/8/2009)
Any other quick global setting that I haven't stumbled upon that might be out there?
Nope.
Enforce through triggers, enforce through stored procedures (and make sure nothing directly accesses the table)...
June 8, 2009 at 12:12 pm
RBarryYoung (6/8/2009)
EdVassie (6/8/2009)
If you are asked 'Is anyone in the office wearing a red shirt' what do you do?
Well the first thing that *I* do when asked this is to...
June 8, 2009 at 12:10 pm
SK (6/8/2009)
Fortunately and unfortunately, this is my first go-round with a currupt/suspect database. Paul's links and references have been great thus far, but I'm kind of stuck.
Emergency mode repair...
June 8, 2009 at 12:09 pm
Dilip Nagle (6/8/2009)
I was under impression that the SQL Server writes Transaction Log in 1st file sequentially and when it is full, it starts writing Transaction Log in 2nd file.
2....
June 8, 2009 at 10:54 am
ps (6/8/2009)
Use DDL Trigger.
DDL triggers do not fire for data changes. They fire for DDL (data definition language) changes only.
June 8, 2009 at 10:46 am
Viewing 15 posts - 38,596 through 38,610 (of 49,571 total)