Viewing 15 posts - 28,666 through 28,680 (of 49,552 total)
GilaMonster (12/29/2010)
Have you considered one of the snapshot isolation levels?
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
January 3, 2011 at 10:59 am
JKSQL (1/3/2011)
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
January 3, 2011 at 10:46 am
Ravi, can you list the indexes on the table? Good chance you have some redundant ones.
My usual indexing strategy in that kind of situation is to tailor indexes for 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
January 3, 2011 at 6:52 am
LutzM (1/1/2011)
You might want to read this article to verify your data types are as efficient as possible.
Which article? 😉
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
January 3, 2011 at 6:50 am
Lowell (1/3/2011)
putting in all those descriptions was incredibly time intensive for someone to do...and you want to delete them because they bother you, not because of a business reason.
I'm exceedingly...
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
January 3, 2011 at 6:45 am
Why is this so incredibly urgent?
If I'm understanding you correctly, you're talking about extended properties. See it this returns the descriptions that you want to be rid of.
SELECT * FROM...
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
January 3, 2011 at 6:36 am
SQL has a type of allocation page called the DCM, the differential change map. When you make a change to a table, the extent that the modified/new rows are in...
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
January 3, 2011 at 6:31 am
Script each foreign key before you drop it (you will need to drop them, disabling is not sufficient). Then, once you've moved all the tables you'll have the scripts 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
January 3, 2011 at 5:43 am
Grab a copy of sysinternals process manager, that can show exactly what app really is holding the file open.
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
January 3, 2011 at 5:37 am
Query sys.dm_db_partition_stats. That gives page count per index. A page is 8kB.
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
January 3, 2011 at 5:34 am
Welcome to 'The Thread' which, in the year or so since its creation become something of a general chat topic where just about anything can come up.
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
January 3, 2011 at 5:32 am
SQL Express 2005 has a hard limit of 4GB. No way around that.
You can get SQL Express 2008 R2, which has a 10GB limit, but be aware that if 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
January 3, 2011 at 5:31 am
If the indexes truly were completely unused then by removing them you free up some space in the database, reduce the overhead for data modifications, reduce the time for index...
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
January 3, 2011 at 4:33 am
pols (12/31/2010)
Hi,I am having two tables. like below.
Sequence_ididNameKeyitem_namerule_id
16761Includes0NULL
26761item160abc
36761item163xyz
46761Requires0NULL
56761item6760abc
66761Only For0NULL
76761Item271abc
86761Item1884xyz
Is there a question here?
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
January 3, 2011 at 1:58 am
Generally you wouldn't. If auto-create stats is on and the optimiser thinks it would be useful to know data distribution of a column, SQL will create the stats by itself....
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
January 2, 2011 at 10:31 pm
Viewing 15 posts - 28,666 through 28,680 (of 49,552 total)