Viewing 13 posts - 61 through 73 (of 73 total)
Adrian Green (8/10/2009)
August 10, 2009 at 7:51 am
oli (8/10/2009)
1. Keywords - Use SQL keywords in capital letters to increase readability
I find that the nice highlighting in SSMS more than adequate and a lot easier on the eyes...
August 10, 2009 at 7:20 am
GilaMonster (8/10/2009)
rja.carnegie (8/10/2009)
August 10, 2009 at 7:11 am
How much space does a variable consume? I assume kilobytes at most typically, which is really nothing at all. I mean, you aren't going to use thousands of...
August 10, 2009 at 6:02 am
Coded language is underhand. It does exist in other fields of endeavour. For instance, a politician dreads being praised for a "brave" decision.
It occurs to me that "Exceptional"...
August 10, 2009 at 5:31 am
MAXDOP 0 -is- the number of cores on the server (allowed to SQL Server, which may be fewer than "all").
So what does MAXDOP 0 achieve?
August 10, 2009 at 4:57 am
I assumed that MAXDOP limited absolutely the number of cores allocated to a session, query, or batch. Is that not so?
I wonder if parallelism-waiting is a fault. Naturally,...
August 10, 2009 at 4:10 am
TheSQLGuru (8/5/2009)
Grant Fritchey (8/5/2009)
I can't support .rar compression files at work (don't ask). Can you zip the files?Grant, aren't you supposed to be doing WORK at work?? 😀
I'd call...
August 6, 2009 at 7:23 am
Although QOD is often described or answered in slightly broken English that suggests a location requiring nchar, I think there are more locations that don't than some people are imagining....
July 24, 2009 at 6:50 am
Fixing the bugs an exercise for the student? 🙂
With similar needs I've been caught out where I'd prefer to include more than one short first word, such as "St"...
June 19, 2009 at 9:47 am
If test.txt is where you're reading data from, that isn't delimited, it's fixed lengths. If it's a one-off job, or even if it isn't, DTS is more capable -...
June 19, 2009 at 9:44 am
I have more experience of 2000's maintenance plan facility, and of DTS. We're only now moving to 2005. Of the tools I know better, I prefer scripts because...
June 19, 2009 at 8:24 am
Technically the QUOTENAME() function should be considered for quoting schema and object names, such as
EXEC ( '
CREATE TABLE [#stupid[reallystupid]]tablename] (i int NOT NULL)
SELECT * FROM [#stupid[reallystupid]]tablename]
SELECT * FROM tempdb.INFORMATION_SCHEMA.TABLES...
June 15, 2009 at 6:18 am
Viewing 13 posts - 61 through 73 (of 73 total)