Topics
Started by
Posts
Last post
Hello folks, I'm currently looking for a script that would accept a schema name as a parameter and …
2 replies
Is there a way one could do BULK INSERT from table to table? meaning bulk insert the output of a qu…
7 replies
I've recently inherited some sql servers (2005) that I have to maintain. My background is mostly S…
4 replies
i'm making transaction base software using sql 2000 . In my program i want to stop insert,update a…
6 replies
Yesterday, I set up perfmon to trace SQL performance. Today, when I started the trace, an error mes…
6 replies
Hi, Following query is taking 1 min to execute. Please suggest improvements? SELECT SUM(COALESCE(DA…
15 replies
I have two really huge views which access many tables.The views execute fine individually, they exe…
1 replies
Hi, The following query involves a few INNER and LEFT joins. The last join (joing ROE table) is a b…
3 replies
Hi all' We have a stored proc which internally calls nearly 50 sp's which internally creating lot o…
12 replies
Hi I use sql server 2005 and I wanted to ask an opinion for the creation of a table with millions o…
13 replies
Hi I'm new to SQLSERVER.What should be the Normal CPU Utilization of SQLSERVER? I checked CPU in …
8 replies
We have a production DB that goes through an archive process each night the Archive DB is basically…
2 replies
I have a table with multiple indexes, each with a separate fill factor ranging from 80 to 95%. Wha…
2 replies
I am looking for some documentation on how to frame a query so that it uses Index seek rather than …
4 replies
if anyone knows of a counter that measures inserts/updates per second or something similar it would…
4 replies
Viewing 15 topics - 361 through 375 (of 2,581 total)
You must be logged in to create new topics.