Viewing 15 posts - 46,741 through 46,755 (of 49,552 total)
gcmcmahon (4/29/2008)
Is this even if they do not know the sa pwd?
Yes, and it works even if the server's in windows authentication only mode.
It's so that an admin cannot accidentally...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 2, 2008 at 9:27 am
If we give you the answer, do we get the job?
I'll give you a hint, but that's all. The database in question still thinks it's replicated.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 2, 2008 at 9:23 am
No.
A snapshot is just the old version of pages from the source DB that have changed since the snapshot was created. Removed from the source DB, it's meaningless as it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 2, 2008 at 9:06 am
Can you post the schema of the table please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 2, 2008 at 9:04 am
Irfan (4/29/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 3:29 pm
No. You should have either /3GB or /PAE enabled. Having them both on on a server with 16+GB memory is asking for problems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 2:55 pm
The database master key is used to encrypt other keys in the DB. It's not there to stop the DB being attached/restored onto another server.
Currently, the way to ensure that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 2:41 pm
That just means that the SPID that reported the condition is sleeping (waiting) until the mini-dump that's created has been written to the drive. You'll see that every time SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 2:20 pm
A index is either unique or it's not unique. To do what you want, you'll probably need a trigger, and it will hurt your insert/update performance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 2:15 pm
Hans Lindgren (4/29/2008)
toniupstny (4/29/2008)
The estimated cost is NEVER is a good estimate of the run duration of a query
No, it's not. The cost is based on the CPU usage, the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 2:12 pm
Jim Russell (4/29/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 2:10 pm
What sleeping condition?
They're not bad-disk related. They're slow disk related. By themselves, these errors don't indicate corruption. They indicate that the IO system is overloaded or very poorly performing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2008 at 1:25 pm
Jpotucek (4/28/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2008 at 8:54 am
Can you post the schema of the tables and their indexes please?
Without that, we're just guessing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2008 at 8:35 am
Proper indexes and up to date statistics. Compiler hints are to be avoided wherever possible.
Can you post the schema of the tables, the indexes defined and the aprox row counts...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2008 at 8:09 am
Viewing 15 posts - 46,741 through 46,755 (of 49,552 total)