Topics
Started by
Posts
Last post
Can we do the selection from the Database table by creating the Table Value Function. Or shall we c…
1 replies
Hello all! We have a Data warehouse that are hosted in a dedicated sql server machine (32Gb memory …
2 replies
I added an index to a table and according to the Estimated Execution Plan the query (a select state…
4 replies
Hi All, We have a SQL server 2005 database with 2000 stored procedure and would to perform the perf…
5 replies
I recently had to delete around 22 million rows out of 30 million rows in a table. How I went about…
4 replies
o if i'm in enterprise manager sql server 2008 and i have a stored proc call. for example exec getU…
1 replies
One of my query is using 4-5 tables using Inner or Left Outer joins. These tables are the main tabl…
9 replies
Team, Is UPDATE STATISTICS operation on columns of NTEXT Data Type Dead Slow. I have few statistics…
1 replies
For the past 2 months on my sql server 2005 Active/passive 64 bit cluster I have had the server bur…
11 replies
Hi All, we are facing issue while running query. when t-sql query run with hard coded value the sql…
1 replies
I had a curious situation recently where a stored procedure ran for 48 hours without completing. C…
3 replies
One of my colleagues has a client whose DBA isnsists on 90% value for the performance counter - SQL…
8 replies
Hi, What's is better? I prefer the third case because my table scps_cadastro_os has more than 1.000…
4 replies
I have a great deal of stored procedures and data integration that need to be optimized. All the S…
2 replies
HI all, Below is 2 query by which i want to fetch query by it execution time for example today is …
1 replies
Viewing 15 topics - 256 through 270 (of 3,249 total)
You must be logged in to create new topics.