Topics
Started by
Posts
Last post
Hello, I stuck with creating plan guide. I got following query: INSERT INTO dbo.table1 (col1, col…
1 replies
One of my clients is running a select statement as part of a report. The problem is that is takes 5…
8 replies
hello, do deadlocks only happen for transactions or two processes trying to update the same record …
3 replies
Hi, Query is: SELECT DISTINCT prof_sec.profile_skeyAS profile_skey, acct_sec.account_skey …
8 replies
Hello, We're using SQL Server 2005 as a Microsoft Business Solutions Navision Data Server and we're…
4 replies
Hi All, I know that UNIONS should be avoided when ever possible. Now I've drawn up some tests to re…
7 replies
Hi all, We are migrating a core application from a sql 2000 server to a new sql 2005 server on new …
8 replies
Hi All, I am new to performance tuning. I wanted to do tune below stored procedure. I can not avoid…
5 replies
Hello I have a table with a unique Identifier column which is the pk (Guid created by a c# applicat…
2 replies
Can anybody suggest me regarding performance in following query. SELECT DISTINCT temp_assoc_obj…
7 replies
Hi, our db is missing out some items while inserting using OPENXML. we are inserting items on…
4 replies
I have a Windows scheduled task on one of my data warehouse servers that calls a batch file that ru…
2 replies
I have a table that is 16 columns wide, and has 1000 (random, unique) inserts per second. They run…
22 replies
Hi All, I just got asked this question today but a work mate, and I didn't have an answer. Other th…
1 replies
Hi All, I've tested this a fair bit and they seem to be the same as I would have expected. but just…
5 replies
Viewing 15 topics - 2,131 through 2,145 (of 3,249 total)
You must be logged in to create new topics.