Viewing 15 posts - 17,101 through 17,115 (of 49,552 total)
Other than that with drop.. create there's potential for queries to use the table between the drop and the create, 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
August 17, 2012 at 11:49 am
Rows in a table don't have a defined order. If you want an order when you retrieve rows from a table you must use the ORDER BY clause, otherwise you...
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
August 17, 2012 at 11:04 am
That can be done in a function, but you need a multi-statement table-valued user defined function, not an inline table-valued user defined function. An inline TVF only allows a single...
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
August 17, 2012 at 10:38 am
The Index insert (clustered) is the insert into the table itself (clustered indexes are the table)
Having indexes on a column doesn't mean that SQL will use a specific join. The...
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
August 17, 2012 at 10:35 am
http://ola.hallengren.com/Versions.html
http://sqlfool.com/2011/06/index-defrag-script-v4-1/
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
August 17, 2012 at 8:47 am
Change your backup jobs to use the new location, use alter database with the MOVE clause and then move your DB files. Details are in BoL.
Action plan: steps you will...
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
August 17, 2012 at 5:43 am
Just as a note to a 'not a DBA', switching to simple recovery is not typically something you'd do to an important DB as that breaks the log chain 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
August 17, 2012 at 4:19 am
SQLDBA360 (8/17/2012)
On this particular database I personally would shrink it because it doesn't appear to be setup corectly, but on the whole your advice is spot on
You'd shrink without knowing...
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
August 17, 2012 at 4:16 am
Shrinking the DB is not only not the solution, it'll potentially make things worse
Please read through this - Managing Transaction Logs[/url] and this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
August 17, 2012 at 3:49 am
Taking a couple steps back... This whole thing is only valid for very, very, very simple queries that qualify for autoparameterisation. Emphasis 'very simple'. It is not at all the...
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
August 17, 2012 at 3:17 am
No. It should just be the use count of the parameterised query. That's the actual plan.
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
August 17, 2012 at 2:55 am
Not that I'm aware of, and no. Prepared are parameterised statements, auto, forced or manually parameterised.
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
August 17, 2012 at 2:36 am
A schema lock is just to prevent the table's structure changing while a query is running against it. If you thought dirty reads was a problem (and it is), imagine...
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
August 16, 2012 at 4:06 pm
Was there a database shrink anywhere in the process? Autoshrink?
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
August 16, 2012 at 11:49 am
So you're saying that if you and I are both making changes to a table at the same time, when you run a commit you also commit my changes 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
August 16, 2012 at 10:55 am
Viewing 15 posts - 17,101 through 17,115 (of 49,552 total)