Viewing 15 posts - 166 through 180 (of 194 total)
The first error message actually looks a lot like the dynamic packet sizing (autotuning) in Windows 7 and what it did to places like Pandora.com (i.e. disconnect every few seconds).
link...
August 31, 2011 at 7:23 am
Short answer is yes you can, but it will probably take Pivoting work and maybe some Dynamic SQL. It would be easier to do a single column with all...
August 29, 2011 at 9:39 am
I thought it was a fine question.
I'm surprised by the number of people who are complaining about the existence of a Test2 db or not. I would have...
August 23, 2011 at 6:50 am
well, from a troubleshooting standpoint it looks like you aren't defining values for your switches of -T and -c... you do for -t (a comma). I've never used the...
August 17, 2011 at 6:36 am
If you are looking at the results in SSMS grid you will only get a single line. the Char(13) + Char(10) of ANSI (or is it ASCII?) new line...
August 3, 2011 at 11:17 am
I tend to eat "alone", but this is because I'm usually talking to the wife, taking a power nap, reading, or otherwise distracting myself from work. I typically have...
August 3, 2011 at 8:06 am
Hey guys,
Score another victory for Jeff and Tally Tables. That is the solution. Using the previously dictated table and entries here's the code. Yes I'm going to...
July 28, 2011 at 10:59 am
ferrarielly (7/28/2011)
I have this store procedure..the problem is that the result is for all fields NULL
What is wrong?
alter PROCEDURE [dbo].[LITABVERIFICAGIACENZA_INSERT] (@Codarticolo VarChar(50),@codlotto VarChar(50)OUTPUT,@giacenza decimal(38,6) OUTPUT, @datamodificalotto datetime output) AS
CREATE TABLE...
July 28, 2011 at 8:27 am
After I posted I realized I hadn't included any sample code, so here is the sample I've got that doesn't work correctly. A coworker wrote this originally but...
July 28, 2011 at 7:55 am
Interesting question... Has nothing to do with a case filter at all. This is a gotcha question seeing if you can spot the extra UNION ALL... it's somewhat misleading.
I...
July 19, 2011 at 9:17 pm
if you are required to use loops, look up either the CURSOR keyword or the WHILE keyword. Advice is, Loops are fine for administrative operations... please don't use them...
July 1, 2011 at 8:10 am
James Goodwin (7/1/2011)
July 1, 2011 at 8:06 am
The relational theory is not confined to Codd's writting. It has evolved and will still evolve.
The only key in relational theory is the candidate key. Or just "key". There is...
June 30, 2011 at 12:11 pm
I thought it was a very good article. Perhaps a few more illustrations of the "normalized" tables that you described (ER diagram maybe?). As to the Anti-NULL zealots......
June 30, 2011 at 6:50 am
Viewing 15 posts - 166 through 180 (of 194 total)