Topics
Started by
Posts
Last post
Here is a fun one. 2 selects like so... select t1.f1, t1.f2, t1.f3 from t1 inner join …
13 replies
Hi Guys, Note: Ignore the smileys in b…
20 replies
I am trying to execute a dynamic SQL as part IF EXISTS statement. I get syntax error problems. Here…
4 replies
Hi Our machin has the values: Pentium 4 2.4GHz Single processor,2GB RAM SQL Server 2000, 6GB DB-Spa…
3 replies
I know this is a very vague question, so I will try to provide some details about our situation. We…
1 replies
there is a third party appliaction running in the company where i work. Recently they have been get…
3 replies
Hi folks, I have a problem with my database. Last night I ran these scripts to reduce database file…
5 replies
When we access a different database from a stored procedure or trigger, we need to qualify the tabl…
2 replies
So, my second emergency as a fledging DBA. There is an account that tries to insert a new …
4 replies
Hi, I am planning to implement a trace using the sp_trace_create, sp_trace_setevent and sp_trace_s…
2 replies
I have a 3-4gb database, and within that database are 3 very large tables, containing several milli…
15 replies
I have this query that takes 36 seconds to run. If I break it into 2 by creating a temp table…
5 replies
Has anyone found a way to tune your way past a lazy table spool without doing a complete re-write? …
1 replies
I have recieved complaints that a Java based Web App seems to be slowing down and even kicking peop…
4 replies
Every time my stored procedure is executed from .NET app it takes up to 1.5 minutes to excute. But …
2 replies
Viewing 15 topics - 976 through 990 (of 2,581 total)
You must be logged in to create new topics.