Forum Replies Created
Viewing 15 posts - 346 through 360 (of 59,059 total)
-
Reply To: How to Delete Large Amounts of Data in Microsoft SQL Server
Good idea for an article but there are a few issues... here's one of them...
Here's your "Disable the Indexes" example...
-- Disable indexes
ALTER INDEX ALL ON YourTable DISABLE
--... -
Reply To: SSIS Question
First of all, the warning was telling you that you have columns that you're doing aggregates like SUM() and COUNT() on contain some NULL values. Are you sure those columns...
-
Reply To: Display More Than 8000 Characters (SQL Spackle)
romain.ferraton 82381 wrote:You can also (since recent SSMS) set the limit of the number of characters returned in the grid for non-XML data (varchar(max) for exemple)
Thanks for the...
-
Reply To: Display More Than 8000 Characters (SQL Spackle)
richardmgreen1 wrote:Bit late to the party on this one (only just seen the article).
Instead of using FOR XML PATH, there's a new function (I've only just started using it on...
-
Reply To: Help with index rebuild
I might get a few eye-rolls from you, in return, because I'm going to tell you to stop doing generic, catch-all, supposed "Best Practice" index maintenance. It's all causing more...
-
Reply To: Daily maintenance plan causing performance problems
Vernon Jimmerson-306463 wrote:I do mean to be of good spirit so please don't take offense.
You've certainly impressed us there.
-
Reply To: Unstuck
Speaking of "stuck"... rumor has it that the good folks at SSC are going to start working on problems like the one I'm getting ready to experience when I hit...
-
Reply To: Unstuck
Rod at work wrote:Jeff, no, I don't have access to the TFS VM's disk to see allocated vs. used disk space.
Bummer. And, yeah... them not "getting it" after all the issues is...
-
Reply To: Unstuck
Rod at work wrote:To this day I don't understand how come no one in IT saw the pattern that adding only a little more disk space and having that consumed within a...
-
Reply To: Check sequential order of status of items
Phil Parkin wrote:Ah yes, there's another thing I should have mentioned! After composing your code, please try running it. Yours fails to run.
The code probably worked perfectly on the OPs machine. ...
-
Reply To: Forum Etiquette: How to post data/code on a forum to get the best help
brian.cook wrote:This was very helpful. I learned some also from it.
I hopefully have posted my current question in a better format and have explained myself well enough.
Thank you
My apologies. Apparently,...
-
Reply To: Weekday different executing procedure directly or executing by SQL Server Agent
If you would post the code you're using, perhaps we could solve all of your problems with a bit of a magic temporal formula that doesn't rely on any settings...
-
Reply To: Pivot Mistake
antonio.perez wrote:Thanks a lot Drew.
It works perfectly
I think you may have a larger issue on your hands... It's a really bad idea to store temporal data as strings.
-
Reply To: SQLExternalMonitoring what is it in sp_who2 result
You'll probably need to look at Task Manager or Resource Monitor to figure out exactly what software is being executed there. Do you have an infrastructure team that might know?
Viewing 15 posts - 346 through 360 (of 59,059 total)