Viewing 15 posts - 26,311 through 26,325 (of 59,102 total)
Brandie Tarvin (8/2/2013)
How many SQL Spackle articles are there?
Yes, I have a reason for asking. But I want to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2013 at 10:21 am
Without seeing the rest of the proc, error line number, etc, it's difficult to tell but it could be an artifact later in the code caused by the date format...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2013 at 10:20 am
And carry a piece of real 90 degree Rebar that you can hum at the wall if you get frustrated instead of taking it out on the people trying to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2013 at 9:48 am
taigovinda (8/3/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2013 at 9:34 am
niladri.primalink (8/3/2013)
I have a stored procedure named 'Bacs_ValidProcessingDateList' when I execute this procedure it is working fine.
It shows me 2568 records. How Can I use top clause with this?
I...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2013 at 9:23 am
david.wright-948385 (8/3/2013)
Steve Jones - SSC Editor (8/2/2013)
...we had some authors of...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2013 at 9:21 am
taigovinda (8/2/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2013 at 11:03 pm
Forgot about the original problem. Since you've already determined that some data exceeds both NVARCHAR(4000) and VARCHAR(8000), then one of the MAX datatypes is appropriate although I'd try to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2013 at 10:45 pm
taigovinda (8/2/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2013 at 10:38 pm
This doesn't answer your question but I've always questioned the use of the Resource Governor on jobs. You know the jobs are there and you know they're going to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2013 at 10:00 pm
taigovinda (8/2/2013)
Thanks. Given that info I will stick with max as I have no need to index by these columns. 😀Tai
Before you jump to that conclusion, please consider the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2013 at 9:35 pm
David McKinney (8/2/2013)
As regards why the article got marked down, I'd suggest that it's because you didn't mention the obvious solution.
You want to sort by the month...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2013 at 7:44 am
Be careful about what you use SET STATISTICS on. If you have any scalar functions in the query, they can look hundreds of times worse than they are because...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2013 at 9:40 pm
I can't help in SSRS but, as a sort of "bump" for you, what kind of total are you looking for?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2013 at 9:34 pm
Steve Jones - SSC Editor (8/1/2013)
jasona.work (8/1/2013)
Steve Jones - SSC Editor (7/31/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2013 at 9:05 pm
Viewing 15 posts - 26,311 through 26,325 (of 59,102 total)