SQLRNNR

Forum Replies Created

Viewing 15 posts - 12,691 through 12,705 (of 19,560 total)

RE: Is our log file too big?

Matt-1034261 (8/31/2010)
It may have been my fault as I think I might have been trying to shrink the data file rather than the log file. I tried again and this...
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

August 31, 2010 at 8:56 am

#1214374
RE: Today's Random Word!

crookj (8/31/2010)
Centripetal force
Joe
centrifugal
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

August 31, 2010 at 8:50 am

#1214368
RE: Are the posted questions getting worse?

Brandie Tarvin (8/31/2010)
Maybe, Alvin. I wonder, though, how many of us are DBA by title, but DB-Everything by practice?
Or DB-Everything by practice with just a different title and the admin...
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

August 31, 2010 at 8:49 am

#1214367
RE: Table Variable vs. Temp Table - errors?

I would have to agree with wayne. Maybe in your CTE you are pulling information from an Int column and then pulling info from a bigint column. 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

August 30, 2010 at 5:54 pm

#1214004
RE: VM Vs Multiple SQL Instances - Which one to go for?

Steve Jones - Editor (8/30/2010)
I like VMs better. Easier to slide to another machine, and I think the memory split can be more efficiently used.
With instances, you can't really control...
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

August 30, 2010 at 5:40 pm

#1214001
RE: did you leave a secure job, what pushed you to move and how did you get on?

Is there any room in your current employment to implement new things / try new methods or sharpen your skills here or there?
I would initiate a pet project to improve...
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

August 30, 2010 at 4:39 pm

#1213987
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/30/2010)
jcrawf02 (8/30/2010)
ok.....so, going to give voice to a thought I've been having lately. If PASS's main goal is to facilitate knowledge, and the value they bring...
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

August 30, 2010 at 4:33 pm

#1213984
RE: Upgrading from 32bit version of SQL Server 2000 (on 64bit OS) to 64bit version of SQL Server 2005

Here is the doc that should be useful and that explains the need to do a side by side for situations such as yours.
http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displayLang=en
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

August 30, 2010 at 2:08 pm

#1213936
RE: Upgrading from 32bit version of SQL Server 2000 (on 64bit OS) to 64bit version of SQL Server 2005

You can do that. I recommend you run the upgrade advisor first though.
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

August 30, 2010 at 1:49 pm

#1213931
RE: Do we need to set the preferred node?

No - it is not required.
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

August 30, 2010 at 1:34 pm

#1213924
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/30/2010)
WayneS (8/30/2010)
Anyone here going to the SQL Server Connections in Las Vegas Nov 1-4?
I will be there. Look me up
I will.
Wayne, call me when you are...
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

August 30, 2010 at 1:31 pm

#1213923
RE: Are the posted questions getting worse?

Trey Staker (8/30/2010)
I really enjoyed Brent O's blog[/url] today.
I do think that is an interesting take on the whole deal.
I read all of the explanations, but one still remains unanswered...
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

August 30, 2010 at 1:25 pm

#1213920
RE: Are the posted questions getting worse?

WayneS (8/30/2010)
Anyone here going to the SQL Server Connections in Las Vegas Nov 1-4?
NO - but I will be here 😉
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

August 30, 2010 at 1:23 pm

#1213919
RE: Integration Services Sources

Thanks for the question.
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

August 30, 2010 at 11:15 am

#1213848
RE: Why is data integrity important?

Thanks for the article - that is a great reminder.
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

August 30, 2010 at 10:33 am

#1213830

Viewing 15 posts - 12,691 through 12,705 (of 19,560 total)