Viewing 15 posts - 41,836 through 41,850 (of 49,571 total)
Lynn Pettis (1/10/2009)
January 11, 2009 at 1:56 am
Look up alter database in Books Online. There's commands to add a file and also to add a filegroup. Or you can do it from the files tab of the...
January 11, 2009 at 1:50 am
Stephanie J Brown (1/10/2009)
Hakima? Which martial art?
Aikido
Mine's aikido, and in terms of dress code, our dojo has two uniforms - the white ghi, and the white ghi...
January 11, 2009 at 1:36 am
Lynn Pettis (1/10/2009)
You know, I don't know? Maybe.
Now that will look impressive in your sig...
January 10, 2009 at 1:20 pm
Typically, you don't. The transaction log is not there for data recovery and there's no built-in way (except for ROLLBACK TRANSACTION) to use the transaction log to undo a transaction.
Additionally,...
January 10, 2009 at 12:55 pm
Lynn Pettis (1/10/2009)
January 10, 2009 at 12:39 pm
What I wear on a particular day depends on what I'm doing. I personally detest skirts and I haven't worn one since highschool (where it was required uniform) and the...
January 10, 2009 at 12:38 pm
Jeff Moden (1/10/2009)
January 10, 2009 at 12:23 pm
Lynn Pettis (1/10/2009)
Sorry, I was watching the last 2 episodes of StarGate Atlantis (had them on DVR).
Any good?
Or it could be a result of the Raid 5 configuration of the...
January 10, 2009 at 1:51 am
Gautam Saha (1/9/2009)
January 10, 2009 at 1:48 am
It's parallelism. It's something that SQL decides to do, not the developer.
Not all of the threads will likely be running and there can be more than the maxdop set or...
January 10, 2009 at 1:02 am
If all the queries that filter on the quid are equalities (hence finding 1 row), I'd put a nonclustered index on the Guid and find somewhere else for the cluster.
I've...
January 10, 2009 at 12:48 am
Digs (1/9/2009)
SO are you saying the code in asp.net codebehind and TSQL 2005 stored proceedures can be hacked ...?????
Anyone that has login rights to the SQL Server and either execute...
January 10, 2009 at 12:45 am
No way to tell.
I'm asking what appears to cause it, not the root cause. What are you generally doing when it happens?
Earlier advice still applies. The best people to contact...
January 10, 2009 at 12:35 am
Gautam Saha (1/9/2009)
Can I break up the database so that it consists of 4 mdf/ndf files
You can. What are you trying to achieve by doing so?
January 9, 2009 at 2:54 pm
Viewing 15 posts - 41,836 through 41,850 (of 49,571 total)