Viewing 15 posts - 26,011 through 26,025 (of 49,552 total)
Wait.
It's rolling back and the rollback has to complete. If you restart SQL, the rollback will continue after the restart.
Check that it's not blocked, check there's nothing it's waiting...
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 21, 2011 at 5:49 am
SQLRNNR (5/20/2011)
I love Gails answer here.
Hey, he asked for a course in the Seattle area. That's in the Seattle area. It's a higher level course. It is mostly administration.
I...
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 20, 2011 at 4:41 pm
You may want to take a read through this, and all the technical documentation it links to http://haacked.com/archive/2007/08/21/i-knew-how-to-validate-an-email-address-until-i.aspx
The following characters are all valid in an email address: ! $ &...
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 20, 2011 at 4:39 pm
http://www.sqlskills.com/Bellevue-20110801.asp
http://www.sqlskills.com/Bellevue-20110808.asp
http://www.sqlskills.com/Bellevue-20110815.asp
http://www.sqlskills.com/Bellevue-20110822.asp
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 20, 2011 at 4:24 pm
Ok, so are the queries actually slow, or are you just concerned about the waits?
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 20, 2011 at 1:48 pm
And the wait types are ????????
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 20, 2011 at 1:39 pm
bdaviduck (5/20/2011)
With regard to "making things faster" -- what do people normally do -- rename every stored procedure and then go through all the code and rename as well?
No....
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 20, 2011 at 1:33 pm
Craig Farrell (5/20/2011)
I don't understand why it's necessary, the ITP's are supposed to be the TS and then some.
Exactly, they're the TS and them some extra stuff that's...
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 20, 2011 at 1:11 pm
SQLRNNR (5/20/2011)
GilaMonster (5/20/2011)
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 20, 2011 at 1:10 pm
See http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3
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 20, 2011 at 1:03 pm
There's no pre-reqs to take the exam, however to get the MCITP certification, you need to hold the MCTS certification.
I wrote my 2008 dev exams out of order, ITP first,...
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 20, 2011 at 1:01 pm
Stay away from 'quote from BoL' type questions, they can be memorised. I like questions where the candidate has to discuss the topic, less chance they swatted up from 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
May 20, 2011 at 12:54 pm
Yes. The restored database is exactly the same as the database was at time of backup. That's structure, data, settings, everything.
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 20, 2011 at 12:51 pm
I need to schedule the two BI ones. Perferably before July when the price goes up. Going to write them cold, no studying. Will be fun, as I barely work...
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 20, 2011 at 12:48 pm
There is a log backup missing between CONX_Prod_20110520170000.trn and CONX_Prod_20110520173000.trn. Either you have a log backup job/maint plan, someone took an ad-hoc log backup or there's a third party tool...
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 20, 2011 at 12:47 pm
Viewing 15 posts - 26,011 through 26,025 (of 49,552 total)