SQLRNNR

Forum Replies Created

Viewing 15 posts - 6,931 through 6,945 (of 19,560 total)

RE: Are the posted questions getting worse?

GilaMonster (2/2/2012)
Anyone interested in proof-reading an article on bulk-logged recovery and minimally logged operations? It's titled as an introductory article, but I read the log and might end up with...
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

February 2, 2012 at 5:21 pm

#1442154
RE: Deleting Duplicated data

Here's another article to help understand the process.
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
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

February 2, 2012 at 10:09 am

#1441952
RE: Today's Random Word!

Ray K (2/2/2012)
SQLRNNR (2/2/2012)
putz
J.J.
http://www.baseball-reference.com/players/p/putzjj01.shtml
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

February 2, 2012 at 8:01 am

#1441855
RE: SSIS 2008 to 2005?

You can't run an SSIS 2008 package from SSIS 2005. You need to have SSIS 2008 installed somewhere and run the package from that server.
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

February 2, 2012 at 6:53 am

#1441779
RE: SSIS 2008 to 2005?

Duplicate post
Post answers here
http://www.sqlservercentral.com/Forums/Topic1245741-364-1.aspx
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

February 2, 2012 at 6:48 am

#1441775
RE: Today's Random Word!

putz
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

February 2, 2012 at 6:47 am

#1441774
RE: SSIS 2008 to 2005?

Charmer (2/2/2012)
Hi,
When i try to execute a package from 2008 to 2005, i get this error...
Are you executing a 2008 package against a 2005 database or are you trying 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

February 2, 2012 at 6:47 am

#1441773
RE: how does order by work when values are the same

If the values are the same in the column used in the order by, the results will be random. You may see the same order of the results after...
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

February 2, 2012 at 6:45 am

#1441771
RE: Stored Procedure Compile issue

Recurs1on (2/2/2012)
We see this kind of thing all the time. In our case, it's not a dramatic as in yours, but we'll have procedures that take 1min to run the...
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

February 2, 2012 at 6:41 am

#1441769
RE: INSERT OUTPUT

Thanks Steve
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

February 2, 2012 at 6:06 am

#1441747
RE: query makes tempdb full

That last order by statement. But I wouldn't be surprised to see other sort operations if the query were to complete and an execution plan could be generated. ...
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

February 1, 2012 at 4:28 pm

#1441489
RE: query makes tempdb full

It also looks like you will be seeing a significant sort operation.
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

February 1, 2012 at 4:22 pm

#1441487
RE: query makes tempdb full

The query is filling up the tempdb probably due to the size of the tables in the query. Reduce the result set and likelihood of filling up the tempdb...
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

February 1, 2012 at 4:21 pm

#1441485
RE: Today's Random Word!

bcsims 90437 (2/1/2012)
JAZZ Master (2/1/2012)
Springer
Spaniel
Excellent dog!!!!!!!!!!
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

February 1, 2012 at 4:17 pm

#1441483
RE: query makes tempdb full

Any good reason a where clause is not being used?
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

February 1, 2012 at 4:13 pm

#1441479

Viewing 15 posts - 6,931 through 6,945 (of 19,560 total)