Viewing 15 posts - 33,676 through 33,690 (of 49,552 total)
Had same thing some time back. Turned out to be a side-effect of the anti-DoS features added in, i think, a service pack of Win server 2003. Details fail me,...
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
March 5, 2010 at 10:05 am
da-zero (3/5/2010)
- never use the build-in slowly changing dimensions wizard
If you make such a statement in an interview, any competent interviewer will immediately follow up with 'Why?'
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
March 5, 2010 at 9:19 am
Homework? Test?
The 'encryption' that protects the SQL passwords is a one-way hash.
If you want to enforce strong password policy, enable password policy on those logins. SQL will take 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
March 5, 2010 at 9:16 am
Welsh Corgi (3/5/2010)
Gail,btw, that was an awesome catch on the cluster.
Not really. It's just about the only reason why SQL wouldn't see a drive that windows can.
I did a...
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
March 5, 2010 at 6:16 am
A CTE is a single query, not a whole set of statements, and it must be a single select, no exec.
If you want dynamic SQL and exec, you'll need...
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
March 5, 2010 at 6:06 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/Topic877452-146-1.aspx
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
March 5, 2010 at 4:11 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/Topic877452-146-1.aspx
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
March 5, 2010 at 4:11 am
VALEK (3/5/2010)
this is very true. though free samples are available to have a feel of the exam. also some tips from those that passed.
If those are from MS or Measure...
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
March 5, 2010 at 4:06 am
Suspended simply means waiting for a resource. So they could have been waiting for a lock, a latch, a memory grant, time on the processor, etc, etc. A look at...
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
March 5, 2010 at 4:03 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/Topic877452-146-1.aspx
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
March 5, 2010 at 4:02 am
In that case the drives are not visible because they are not dependencies of the SLQ service (set up in cluster admin). For a clustered SQL server to see a...
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
March 5, 2010 at 3:55 am
indid = 255 are text images, not statistics.
Statistics have indid anywhere between 2 and 249 and are identified either using the INDEXPROPERTY function ("IsStatistics" property) or by noting 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
March 4, 2010 at 11:11 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic877313-145-1.aspx
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
March 4, 2010 at 6:07 pm
CirquedeSQLeil (3/4/2010)
I had a DBA scoff at me once when I said a truncate could be rolled back.
Same. I invited him over to my desk and showed, in code,...
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
March 4, 2010 at 6:05 pm
aaron.reese (3/4/2010)
Delete writes to the transaction log and will roll back if there is an issue whereas Truncate does not.
Not true.
Truncate is a logged operation, it can be...
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
March 4, 2010 at 5:32 pm
Viewing 15 posts - 33,676 through 33,690 (of 49,552 total)