Viewing 15 posts - 4,336 through 4,350 (of 18,926 total)
Seriously, call a pro. Ideally the one who has setup your systems.
You're not the man to complete that task.
July 27, 2011 at 6:34 pm
SQLRNNR (7/27/2011)
Chad Crawford (7/27/2011)
Useless post just to make 2,285Sorry - I thought I saw the bandwagon start up, and I could use a lift.
Useless post to make umm, whatever...
July 27, 2011 at 3:53 pm
Well ya, convert both to varchar(x) and then concat.
But why do you need to do this? Never seen that before...
July 27, 2011 at 3:52 pm
Grubb (7/27/2011)
Thanks for the suggestions...So, it's not unusual, then, to see such log usage during index rebuilds, based on the size of the large tables.....
If you tell me that your...
July 27, 2011 at 3:14 pm
Grubb (7/27/2011)
We use something similar...It's not blindly rebuilding them.
This should give you the max tlog backup size per hour per day (or whatever your schedule is) for the last month.
What's...
July 27, 2011 at 3:11 pm
Here's my full thoughts process to get there.
http://www.sqlservercentral.com/Forums/Topic1126147-146-1.aspx
July 27, 2011 at 3:02 pm
Easy, don't blindly rebuild / reorg every single darn index in the DB (it's what is done in the maintenance plans).
This is what I use :
http://sqlfool.com/2010/04/index-defrag-script-v4-0/
Over time I was able...
July 27, 2011 at 2:54 pm
thermanson (7/27/2011)
Thanks for the suggestion, but unfortunately not everything is the same between the two files so I can simply copy it over.
Ok, how about re-importing the object(s) under new...
July 27, 2011 at 2:51 pm
jeff.mason (7/27/2011)
Ninja's_RGR'us (7/27/2011)
jeff.mason (7/27/2011)
5 pages of discussion for a question like this? Seriously? I think we are getting carried away now.
So why do you insist on compounding the...
July 27, 2011 at 2:47 pm
Why can't it be a GUID? Sounds like the "easiest" solution here. You'll have 99.999999999999999% success on the first try to generate a new unique key and it...
July 27, 2011 at 2:46 pm
Ya but if it works on user 1 and not user 2 (assuming the same exact query) what would it behave differently?
Any way to just copy the "working" db to...
July 27, 2011 at 2:40 pm
Jeff Moden (7/27/2011)
btull89 (7/27/2011)
Thanks for all of the feedback! It was helpful.
I'll add to all of this. Use thoughtful comments and section headers. IT makes life a whole...
July 27, 2011 at 2:34 pm
mtillman-921105 (7/27/2011)
I think we just visited the "Some things you just don't wanna know" domain. :sick:
Just because you said that we all wanna know... so what's the URL?
July 27, 2011 at 2:33 pm
Jeff Moden (7/27/2011)
Ninja's_RGR'us (7/27/2011)
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1I just use the basic cpu, reads, writes, duration columns.
Those events are nice to use in their own rights :
Performance:Showplan XML Statistics Profile
SP:StmtCompleted
SQL:StmtCompleted
I also throw in...
July 27, 2011 at 2:32 pm
mtillman-921105 (7/27/2011)
Actually, bacteria gas. (CO2) Delightful, isn't it? And I like swiss cheese.So I guess Baby Swiss uses mini-bacteria?
Anti-matter.
July 27, 2011 at 2:24 pm
Viewing 15 posts - 4,336 through 4,350 (of 18,926 total)