SQLRNNR

Forum Replies Created

Viewing 15 posts - 18,361 through 18,375 (of 19,560 total)

RE: WHERE filter is killing my query against a SQL Server 2005 database

I would go for the query rewrites at this point.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 3:33 pm

#1099286
RE: Log file help needed

With the recovery model set to full, you should consider performing Log backups (15min, 30 min or some other interval).
Or, if there is no need to be able to perform...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 3:32 pm

#1099285
RE: keyset cursors

AndrewSQLDBA (1/5/2010)
I believe that you should NEVER use a cursor of any type. There is always a better way.
Andrew SQLDBA
Good Advice
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 2:58 pm

#1099266
RE: moving sql servers to a new ou

John Rowan (1/5/2010)
This should be treated just like any other server move within your network. This is a network access issue, not a SQL Server one. As long...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 2:54 pm

#1099264
RE: Log file help needed

c00ler01 (1/5/2010)
Hi,
I would turn off 6 gb limit since 1 day it might crash horribly.work on a new process to assess the growth.10% in my opinion should be changed to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 2:46 pm

#1099257
RE: Log file help needed

Quinn-793124 (1/5/2010)
We have a GIS system based in SQL Server 2005. The log file from one of the DB's keeps filling up and we cannot figure out what is causing...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 2:40 pm

#1099253
RE: Are the posted questions getting worse?

GilaMonster (1/5/2010)
Lynn Pettis (1/5/2010)
CirquedeSQLeil (1/5/2010)
Urgent, going to lose my job.
http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx
And then three weeks later...
http://www.sqlservercentral.com/Forums/Topic842291-149-1.aspx?Update=1
Hmmm...I guess the prof gave him an extension?
Actually, nothing earlier indicated that it was urgent, so more...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 2:23 pm

#1099246
RE: Are the posted questions getting worse?

GSquared (1/5/2010)
CirquedeSQLeil (1/5/2010)
Hey Gus, I have an urgent need for a stored proc. It needs to join an Oracle, DB2, and SQL table and be heterogeneous.
I need it done...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 2:21 pm

#1099242
RE: Stored Procedure Syntax

Thanks for the update.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 1:43 pm

#1099220
RE: Are the posted questions getting worse?

Hey Gus, I have an urgent need for a stored proc. It needs to join an Oracle, DB2, and SQL table and be heterogeneous.
I need it done 3 weeks...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 1:42 pm

#1099219
RE: Are the posted questions getting worse?

Lynn Pettis (1/5/2010)
And then Gus gives him some code. Think the OP will even respond?
Gus is still riding that emotional high from the new employment opp. He can...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 1:39 pm

#1099216
RE: Are the posted questions getting worse?

Lynn Pettis (1/5/2010)
Alvin Ramard (1/5/2010)
Lynn Pettis (1/5/2010)
CirquedeSQLeil (1/5/2010)
Lynn Pettis (1/5/2010)
CirquedeSQLeil (1/5/2010)
Urgent, going to lose my job.
http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx
And then three weeks later...
http://www.sqlservercentral.com/Forums/Topic842291-149-1.aspx?Update=1
Hmmm...I guess the prof gave him an extension?
Actually, nothing earlier indicated...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 1:14 pm

#1099193
RE: Are the posted questions getting worse?

Lynn Pettis (1/5/2010)
CirquedeSQLeil (1/5/2010)
Urgent, going to lose my job.
http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx
And then three weeks later...
http://www.sqlservercentral.com/Forums/Topic842291-149-1.aspx?Update=1
Hmmm...I guess the prof gave him an extension?
Actually, nothing earlier indicated that it was urgent, so more like...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 12:54 pm

#1099175
RE: Are the posted questions getting worse?

Urgent, going to lose my job.
http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx
And then three weeks later...
http://www.sqlservercentral.com/Forums/Topic842291-149-1.aspx?Update=1
Hmmm...I guess the prof gave him an extension?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 12:37 pm

#1099161
RE: Please Reply. I need a stored procedure based on some conditions.

Based on the prior thread, you posted you would try the things we suggested. If that has been done, then please show us what you have done.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

January 5, 2010 at 12:34 pm

#1099160

Viewing 15 posts - 18,361 through 18,375 (of 19,560 total)