Viewing 15 posts - 28,171 through 28,185 (of 49,552 total)
Craig Farrell (1/25/2011)
I've got it pretty good at the moment...
Wish I could say the same, as I'm sure my near-constant rants (whining) has implied. Starting to think about alternatives, and...
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
January 25, 2011 at 11:31 am
Little Nick (1/25/2011)
Can you give me a steps to address the size as mentioned?
Did you read the article I referenced? (I'm assuming not because it answers exactly that question)
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
January 25, 2011 at 11:24 am
SAnjy N (1/25/2011)
And I am not comfortable with Execution Plans. How to read them!
Look at the post right above this one. Look at the books that the author of 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
January 25, 2011 at 11:23 am
I would suggest you speak to the IT team about that policy. It's an appallingly bad security practice for an individual's domain login to be used for scheduled tasks (password...
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
January 25, 2011 at 11:19 am
ALZDBA (1/25/2011)
Sheer luxury :Wow:at least if you compare it to most of us :blink:
Yup. Wish I was in that position.
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
January 25, 2011 at 11:11 am
tim.royal (1/25/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
January 25, 2011 at 11:09 am
koustav_1982 (1/25/2011)
which one is better among these 2 in terms of performance and best practice:1.where col1=@colValue or col1 is null
2.where col1 is null or col1=@colValue
Those two where clauses (as...
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
January 25, 2011 at 11:08 am
durai nagarajan (1/25/2011)
you mean to say it is not possible.
Err, no that's not what I said at all.
SQL agent runs under a specific windows service account (check the SQL Server...
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
January 25, 2011 at 8:51 am
Tim L-309246 (1/25/2011)
In http://www.sqlservercentral.com/articles/SQL+Server/70505/it says, "Best practices call for tempdb to have one datafile per processor (core) and all to be of the same initial size and growth."
Not necessarily.
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
January 25, 2011 at 8:28 am
Koen (da-zero) (1/25/2011)
(I should've been more specific)
But now I look at it, it can also be that person's signature....
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
January 25, 2011 at 8:07 am
Assuming the backup is run by SQL Agent, it's run under the security context of the SQL Agent service account.
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
January 25, 2011 at 8:02 am
TheSQLGuru (1/25/2011)
GilaMonster (1/24/2011)
Unless you had a trace or trigger present when the changes were made, you cannot go back and get details of what happened.
Not true. If you 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
January 25, 2011 at 7:58 am
ALTER TABLE <TableName> ALTER COLUMN <ColumnName> DATETIME
Don't use the GUI, it recreates tables and takes far longer and far more resources than necessary (hence that warning)
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
January 25, 2011 at 7:49 am
Google?
I don't have any handy.
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
January 25, 2011 at 6:58 am
Koen (da-zero) (1/25/2011)
http://www.sqlservercentral.com/Forums/Topic1053001-146-1.aspxSometimes when a read a topic, I can't help myself thinking:
Wait. Wut?
He was looking through the database maintenance plan for the autogrow task, for anyone interested.
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
January 25, 2011 at 6:57 am
Viewing 15 posts - 28,171 through 28,185 (of 49,552 total)