On this issue of index, what are the implications of having duplicate indexes. I have some on my inherited server and I want to gwet rid of the duplicates. However, I want to know what the implications will be. Thanks.
2003-12-30
Could your TEMPDB be in the fast I/O RAID disks than your user databases?
2003-12-30
1 reads
How is the reindexing being done? dbcc reindex updates statistics but if you are using indexdefrag I believe the statistics are not updated. Might be worth looking into if you did not write the weekly process.
2003-12-30
We have a small DB 25G. I have found that I get better performance when I update the statistics. so much so, that I now update every night. Curtis Smith Application Dev. Mgr DBA
2003-12-30
Doesn't fit to size horizontically? Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-29
1 reads
Thanks Steve & noeld. Steve - I'll add the table aliases and check out CAST (do you have a good URL for that handy?) Noeld - yes - the app is running now fine in Access, and I will keep this one there. I'm just trying to convert it into tsql to see what changes […]
2003-12-29
1 reads
The First is that instead of where cnt > 1 Should be deleted and after "group by" just write having count(*)>1 The Second is treaky but, why are you selecting * and the a field that is supposed to be taken from the select statement ? And by the way Your query is formated in […]
2003-12-29
1 reads
for the first one, you need a table alias, so select a.* from (select....) a where a.cnt > 1 For the 2nd, look up CAST in BOL. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-29
1 reads
You seem to be using the "Identity" column for more than "Idnetity". Can you explain why? Their are many ways to generate a series of integers, terporary or permanant. You might want to consider an alternative to altering the identity column. -Isaiah
2003-12-23
2 reads
Here is my 2 cents worth. I understand edwin_fredrick's point and he is quite right in brining it up. But, a scoring system is of little use IMHO. You can judge the person's knowledge from the quality of the answer. You have a choice to decide which solution works for you best. Also, I am […]
2003-12-23
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers