Viewing 15 posts - 29,731 through 29,745 (of 49,552 total)
That info is not recorded anywhere automatically.
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
October 26, 2010 at 2:46 am
My guess would be statistics, but there are lots of possible causes and without more info it's impossible to say 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
October 26, 2010 at 2:45 am
SKYBVI (10/25/2010)
So, that means you want to say that i can do shrinking but again whenever I perform the index rebuilds, the log file will again increase and then...
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
October 26, 2010 at 2:41 am
Sure that select's not part of a longer transaction that does have stuff to rollback?
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
October 26, 2010 at 2:38 am
http://www.sqlservercentral.com/articles/books/65831
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
October 25, 2010 at 2:42 pm
Either change your maintenance so that you're not rebuilding every single index no matter what the fragmentation, or get more space to handle the large logs. Shrinking anything is 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
October 25, 2010 at 2:36 pm
CELKO (10/25/2010)
The best book for a complete beginner is THE MANGA GUIDE TO DATABASES.
Awesome book, even for the not-so-beginner.
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
October 25, 2010 at 1:07 pm
jay.supersaiyan (10/25/2010)
i kno "go" isnt a part of t-sql.but the statement i wrote shld get executed.
it isnt.why??
if i remove "go" it works fine
why???
No idea. It looks fine.
What's the error you're...
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
October 25, 2010 at 12:38 pm
sanjays-735734 (10/25/2010)
you have to use either ";" or "GO"but not both of them.
both are batch separator
That is not true.
The ; is a statement delimiter. It shows where the end of...
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
October 25, 2010 at 12:37 pm
SKYBVI (10/25/2010)
I ran a maintenance plan in the weekend on a prod server.
It had steps of checking database integrity, rebuilding indexes, updating stats and again checking database...
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
October 25, 2010 at 12:15 pm
It's simply a batch delimiter. It tells the client tool where to break apart batches to send to SQL. It is not actually a SQL command.
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
October 25, 2010 at 12:13 pm
Brandie Tarvin (10/25/2010)
Thanks, Gail. I just wasn't sure if R2 was being treated as a separate version or as the "upgrade" to the regular 2k8.
It's a totally separate version. Can't...
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
October 25, 2010 at 12:08 pm
SQL 2008 SP2 got released just a couple weeks back.
That's like asking if MS is going to continue to patch SQL 2005 or push everyone to 2008 (2005 SP3 CU...
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
October 25, 2010 at 9:50 am
Tom.Thomson (10/25/2010)
I'm definitely one of those who prefers a quick solution without work. Essentially I'm extremely lazy.
I think most good developers are to some degree.
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
October 25, 2010 at 9:43 am
ravisamigo (10/25/2010)
How fast are they growing? -----> how I can check this pls
You monitor their size over a period of time and see how the size changes.
If you shrink 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
October 25, 2010 at 8:43 am
Viewing 15 posts - 29,731 through 29,745 (of 49,552 total)