Forum Replies Created
Viewing 15 posts - 331 through 345 (of 59,048 total)
-
Reply To: Keep. It. Simple.
Doing a "bump" so people can see page 2.
-
Reply To: Keep. It. Simple.
Steve Jones - SSC Editor wrote:Certainly learning your existing tools well is important. However, I think you should also be learning new skills and judging when they are useful. That means lots of tests.
For...
-
Reply To: Everything is Code
From the Article:
That's a tough process to implement, and one many companies don't spend the time doing, but for those that do, they end up deploying many...
-
Reply To: Keep. It. Simple.
Great article and links, Steve. Thank you.
Fishing has been perfected. There are no new ways to entice fish to take your bait.
https://getpocket.com/explore/item/timeless-fishing-skills
An old-fashioned cedar plug is a simple but...
-
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,...
Viewing 15 posts - 331 through 345 (of 59,048 total)