Viewing 15 posts - 32,941 through 32,955 (of 49,552 total)
It depends.
The two are not directly exchangeable and are used for different reasons. Just saying 5 tables of x rows is not enough to make a decision.
Is the query only...
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 12, 2010 at 5:47 am
There's no need to shrink to reduce the backup size. A backup only backs up allocated extents. If 99% of the db is empty space, then the backup will 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
May 12, 2010 at 5:45 am
satya.sakamuri (5/12/2010)
actually i was assigned to get more information about Index and and also given a table and asked me to create index to that table.
Did you try google?
Assigned?...
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 12, 2010 at 5:40 am
That kind of formatting should be done in your front end application, not in SQL Server. While SQL can do it, it's not a good place.
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 12, 2010 at 3:10 am
Did the people who made this suggestion give a reason?
I suppose you could reimplement SSIS yourself in .net, but it would be a massive waste of time and resources.
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 12, 2010 at 3:09 am
Do not ever run DTA against a production database. If you use it at all, you should run it against a copy of the databsae on a dev or test...
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 12, 2010 at 3:04 am
The Dixie Flatline (5/11/2010)
Gianluca, did I understand you to say that queries against views don't have their query plans cached? Surely not.
Views do not have cached exec plans....
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 12, 2010 at 1:03 am
Why reinvent the wheel? There's several good index rebuild scripts available, well tested and well used.
http://sqlfool.com/2010/04/index-defrag-script-v4-0/
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 12, 2010 at 12:36 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic920145-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
May 12, 2010 at 12:31 am
mahesh.vsp (5/11/2010)
How to recover or make the customer in safer zone without loosing the 5 days data??
Restore the pre-upgrade backup to SQL 2000. Use a tool like Redgate's SQL Data...
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 12, 2010 at 12:25 am
This is what I was talking about. Ok, join was probably the wrong term to use, there's technically no join. Still, there's a choice between using the NC index to...
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 11, 2010 at 3:19 pm
Lowell (5/11/2010)
Depending on the severity of the performance problems, You might want to consider bringing in a consutant, rather than looking for free advice.
Seconded. Benefit is that a consultant can...
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 11, 2010 at 2:09 pm
eric_russell 13013 (5/11/2010)
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 11, 2010 at 2:03 pm
What level of work is this for?
Do you just have to produce a summary of a particular area? Say, how a particular feature works, how it's used, etc?
Is this 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 11, 2010 at 11:56 am
Is the 'trunc log on checkpoint' option enabled?
Can you try switching to simple, back to full and take a full backup?
You sure that the DB that's failing and the DB...
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 11, 2010 at 9:17 am
Viewing 15 posts - 32,941 through 32,955 (of 49,552 total)