Viewing 15 posts - 1,336 through 1,350 (of 1,838 total)
Deny Christian (10/11/2016)
...Integrity-->backup-->reorganize-->rebuild index-->clean up
I want to make job schedules based on these criteria.
whether to separate or can be made a whole job?
I'm not sure I entirely understand the question,...
October 11, 2016 at 7:44 am
Unfortunately I think some of the problems originate with Microsoft's documentation itself. Sure there's MSDN and TechNet resources online, but I remember back when I was first getting into...
October 10, 2016 at 7:36 am
I've setup something similar before, but I used OPENROWSET instead. I tried a few different things but I found if I was calling a stored procedure I had to...
October 7, 2016 at 3:01 pm
I had a couple of comments on this article. In general I thought it was good, however, there's a couple of overlooked key points here I'd like to bring...
August 22, 2016 at 10:47 am
Gary Varga (7/25/2016)
Chris Harshman (7/25/2016)
July 26, 2016 at 6:30 am
Where I work, the developers do a lot of test driven development for their C# work, but a limiting factor for them doing more on the database side is the...
July 25, 2016 at 10:49 am
Where I'm working, we're still in the middle of our SQL Server 2014 rollout. Even on servers that are on 2014, I've had to turn off the new cardinality...
June 29, 2016 at 9:50 am
bob.probst (9/11/2014)
June 24, 2016 at 10:45 am
I think Microsoft's current cycle of 2 year major releases and 2 month cumulative updates shows that they still don't understand their customers (the corporate world), their needs, how they...
May 2, 2016 at 10:22 am
<oops this is a duplicate of someone else's post>
March 17, 2016 at 3:08 pm
Tears of joy fill your eyes are you are looking at a perfectly designed fourth-normal-form diagram!
hmm... I would be skeptically cautious about a database implemented completely in perfect fourth-normal-form. ...
December 22, 2015 at 10:23 am
RonKyle (10/16/2015)
This has always bothered me: What really is meant by "business logic"?
This is a good point, and someone else has also mentioned it. As you point...
October 16, 2015 at 12:18 pm
I've read before some interesting articles about a concept called the "cone of uncertainty". Essentially estimating too precise too early leads to poor estimation. Software projects tend to...
September 1, 2015 at 10:50 am
Eric M Russell (7/24/2015)
July 24, 2015 at 10:48 am
I think it makes perfect sense to have FORMAT function work on numeric values from right to left. Consider the following:
SELECT FORMAT(1234,'###,###,###')
June 2, 2015 at 11:05 am
Viewing 15 posts - 1,336 through 1,350 (of 1,838 total)