Viewing 15 posts - 17,866 through 17,880 (of 49,552 total)
If you use the maintenance plan task, it will update everything.
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
June 29, 2012 at 9:09 am
SQL 2000 often showed poor behaviour with this form of query:
WHERE Col1 = A OR Col2 = B OR Col3 = C
Ors with multiple columns. I don't recall any problems...
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
June 29, 2012 at 9:01 am
No, no, no, no!!!!
SQL is designed to use as much memory as it can. It's an optimisation. It makes the query processing more efficient and reduces IO load. 2GB 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
June 29, 2012 at 8:46 am
Some behaviour likely changed between SQL 6.5 and SQL 7. Nothing more recent than that though.
WHERE Column IN ('Value1') is completely equivalent to WHERE Column = 'Value1' and WHERE Column...
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
June 29, 2012 at 8:34 am
ben.brugman (6/29/2012)
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
June 29, 2012 at 6:35 am
10.00 is SQL Server 2008. 10.50 is SQL Server 2008 R2. It's a different version of SQL (like 2005/2008), not a matter of patches.
If you're using SQL Express, you need...
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
June 29, 2012 at 2:10 am
You may want to take a read through these:
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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
June 29, 2012 at 2:04 am
No.
http://sqlskills.com/BLOGS/PAUL/post/Debunking-a-couple-of-myths-around-full-database-backups.aspx
http://sqlskills.com/BLOGS/PAUL/post/More-on-how-much-transaction-log-a-full-backup-includes.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
June 28, 2012 at 2:27 pm
Braindumps are cheating. They are actual questions taken from the exams in violation of the NDA that all exam takers must accept. Using or distributing braindumps can result in your...
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
June 28, 2012 at 10:24 am
When doing updates to index keys, SQL does not do them as inplace updates, they will be converted into a delete/insert pair. This is why one of the guidelines for...
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
June 28, 2012 at 6:14 am
Reddy Ksr (6/28/2012)
Not only for innerone transaction as mentioned above reply, even i committed the outerone transaction
You didn't commit the outermost transaction. Naming of transactions is purely for documentation, it...
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
June 28, 2012 at 6:08 am
This may be why...
pleinplus_restyle sysft_zoektekst S:\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\zoektekstplepl_restyle FULLTEXT 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
June 27, 2012 at 3:42 pm
Books Online, the deprecation pages. Probably about the best.
It is about syntax, how it's interpreted, what's allowed and what's not.
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
June 27, 2012 at 2:01 pm
One general comment. Single-column nonclustered indexes are generally useless unless you make a habit of writing queries like SELECT col1 from table WHERE col1 = @var1
Widen [IX_tPlGroupSubgroupMap_6] ON [dbo].[tPlGroupSubgroupMap] include...
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
June 27, 2012 at 1:08 pm
You absolutely sure there's only one data file of 6GB?
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
June 27, 2012 at 12:57 pm
Viewing 15 posts - 17,866 through 17,880 (of 49,552 total)