Viewing 15 posts - 9,436 through 9,450 (of 49,552 total)
To concatenate values together...
location = ''.join(['New','south','wales'])
"This will feel natural and elegant to the initiated."
and I thought readability was crucial.
Edit: The snide comments are more directed to the training course than...
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 2, 2014 at 6:57 am
Restore an earlier backup which isn't corrupt. You should know which is the latest clean backup, it'll be the one right before your scheduled checkDB started failing (you do have...
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 2, 2014 at 6:46 am
Do some research on latch timeouts.
It's not database corruption, it's a latch wait timing out (shouldn't happen). You may need to open a case with product support.
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 2, 2014 at 6:39 am
Koen Verbeeck (4/2/2014)
TheComedian (4/2/2014)
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 2, 2014 at 6:35 am
paul.knibbs (4/2/2014)
GilaMonster (4/2/2014)
It's better because now you don't have all those unnecessary starting and ending characters, and you'll avoid the arguments about where to place those brackets.
😉
Pah! Everyone knows...
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 2, 2014 at 6:27 am
Restore from a clean backup.
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 2, 2014 at 6:23 am
Ok......
Guideline for python code:
"Explicit is better than implicit"
I can agree with that, it's something I argue for when teaching T-SQL. Be explicit.
Then, from the style guide for python:
Bad form:
if attr...
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 2, 2014 at 6:22 am
Readability is crucial
Beautiful is better than ugly
Simple is better than complex
It's better because now you don't have all those unnecessary starting and ending characters, and you'll avoid the arguments about...
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 2, 2014 at 6:13 am
paul.knibbs (4/2/2014)
Python? Isn't that the one where the amount of whitespace at the start of each line is part of the syntax of the language?
Yes, indeed. The indentation determines which...
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 2, 2014 at 5:52 am
hans.pret (4/2/2014)
I reviewed the sql logs again and saw that a checkpoint is created in the master database every time the server is restarted.
A checkpoint is run. Not created. It'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
April 2, 2014 at 5:36 am
Ratheesh.K.Nair (4/2/2014)
We had an issue here were our database got corrupted ,senior dba's are pointing that it was due to running CHECKTABLE. What you think.
No.
Got below message from SQL error...
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 2, 2014 at 5:27 am
This may be of some help: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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 2, 2014 at 5:24 am
Absolutely impossible to say.
Indexes are created to support the queries that run against that table. Hence the queries will determine which (if either) of those index options are appropriate.
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 2, 2014 at 5:21 am
SQL runs a consistency check on that table. If you stop the execution, it stops.
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 2, 2014 at 12:17 am
How about having the test software crash at the end of your MCM knowledge exam (5 hour exam from hell) and they can't tell you for more than an hour...
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 2, 2014 at 12:16 am
Viewing 15 posts - 9,436 through 9,450 (of 49,552 total)