Topics
Started by
Posts
Last post
in sql 7.0 I have a table with many indices that show up in the "sp_help ATable". When I run a quer…
1 replies
Hi, Say I've got a table with a composite index on columns A, B, C, D, and E. Say I've also g…
2 replies
I have a table that after running a DBCC DBREINDEX whos the following results when a DBCC SHOWCONTI…
1 replies
Hi The query I use returns statistic data. Actualy there are more than 10Mio. records in this table…
6 replies
Hello, Could someone give me some general guidance on what types of things one should take note of …
2 replies
I've always thought, maybe wrongly, that if you have two variations of the same query side by side …
1 replies
Hi all, we have an development-server, an integration-test-server and a production server. t…
4 replies
Hi guys, What will be the correct way of structuring this query in order to maximize performance. S…
3 replies
Got a question for anyone who has some input. My development team and I are looking at rework…
1 replies
Hi, We have an OLTP + some reporting on the system with 600+ connections, 30 gb database …
5 replies
I am attempting to rebuild Indexes on a 136GB database. They are all non-clustered Indexes. All o…
8 replies
dbcc showcontig shows my system tables are very fragmented both internally and externally. Does fra…
7 replies
In one of the modules of our application (SqL server 2000, Windows 2003,vb.net), we get ocassional …
3 replies
I have 2 SQL Servers and the same database on both. On the first one I'm runing a query from a stor…
7 replies
We have replaced a single box running SQL with a three-node cluster, and a SAN for storage. Perform…
2 replies
Viewing 15 topics - 1,201 through 1,215 (of 2,581 total)
You must be logged in to create new topics.