Topics
Started by
Posts
Last post
Hi all, A query that involves an outer join operation runs very slowly in Microsoft SQL Server 200…
5 replies
Hi, I have 70million records table having email column.I want to add primary key to the email colu…
13 replies
Hi, my query (as shown below) is very slow to return its result from a a few tables. It takes about…
11 replies
Hi Im looking at building brand new SQL 2005 infrastructure for our company. Looking at clustering…
8 replies
Hi, How to delete Primary key created in design view of a table with 35 Million records how long i…
2 replies
when I rebuild index with (online =on ),the avg_fragmentation_in_percent decrease;but,when I rebuil…
2 replies
Does anyone have any recommendations for SQL performance monitoring tools? I'm aware there are many…
8 replies
Hi, We have a requirement to Merge six 12millions data tables into single Table.All the tables a…
10 replies
I'm rereading this section in the MCTS Exam 70-433 book for SQL Server Development titled Technique…
3 replies
Hi, I have a discussion with my collegue about these 2 statements. I know that SP_UPDATESTATS is do…
3 replies
Hi all, I got high numbers in SQL Comiplations/Sec and lower number in SQL re-Compilatios/sec using…
4 replies
I need some assistance in tuning a query in order to get the best performance. The table could fea…
22 replies
Hi, I have a view which selects the data with 12 joins in it... can you give me suggestions how ca…
36 replies
I would like to know the percentage at which you would have to defragment your indexes?
9 replies
Hi folks, I'm usually an ASP.NET developer. That's why I hit a wall while diagnosing a slow query. …
6 replies
Viewing 15 topics - 1,471 through 1,485 (of 3,249 total)
You must be logged in to create new topics.