Viewing 15 posts - 33,556 through 33,570 (of 59,102 total)
I'm definitely for that. Although I can certainly understand why some people might be interested in all the fancy relational and hierarchical calculus, some folks just want a simple...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 7:14 pm
Just a word of caution... actually, a warning of danger. 😀 Seemingly innocent table hints such as WITH(NOLOCK) and similar Transaction Isolation Level hints can produce some very incorrect...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 6:48 pm
MikeAngelastro-571287 (6/20/2011)
Thanks for your kind comments. Jeff, I read both of your links and added a bookmark for each one. They actually contain advice on...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 6:32 pm
GSquared (6/20/2011)
Jeff Moden (6/20/2011)
GSquared (6/20/2011)
He's very technically proficient
Considering that he recently recommended FK's on First and LastName columns and he still uses a While Loop/Push Stack to convert from an...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 5:42 pm
SQLRNNR (6/20/2011)
Jeff Moden (6/19/2011)
SQLRNNR (6/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 11:01 am
BCP and BULK INSERT are virtually identical now-a-days. Neither will handle true CSV (with text qualifiers, etc) without a bit of work. If the text qualifiers are used...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 8:00 am
GSquared (6/20/2011)
He's very technically proficient
Considering that he recently recommended FK's on First and LastName columns and he still uses a While Loop/Push Stack to convert from an Adjacency List to...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 7:36 am
That's why I wanted to know if there will only and always be just 3 occurances so we can use a singe CHARINDEX on the REVERSE image of the string...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 7:28 am
Jeff Moden (6/19/2011)
dec_obrien (4/2/2007)
I'd like to guesstimate how much space is required for a 2005 database and log file. I can calculate the size of the tables...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 7:25 am
Naked Ape (6/19/2011)
SELECT sales.Project, rep1.DisplayName, rep2.DisplayName, rep3.DisplayName, rep4.DisplayName, sales.Spend
FROM [Table 1]...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 4:55 am
No... it's not just you. Something has gone dreadfully wrong (I hope I have a copy somewhere). I send an email to Steve Jones.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 20, 2011 at 4:21 am
glen.wass (6/16/2011)
so Cheat is < than cheat
It really does "Depend". What it depends on is the default server collation, the collation of a given column in the table when...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 9:08 pm
CELKO (6/18/2011)
Avoid procedural code in SQL whenever you can. Recursive CTEs are really cursor loops, not full recursion...
That's funny coming from a guy who's famous for using a 1960's Push-Stack/While...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 8:48 pm
dec_obrien (4/2/2007)
I'd like to guesstimate how much space is required for a 2005 database and log file. I can calculate the size of the tables but how...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 8:32 pm
ankit.shukla1105 (6/19/2011)
-1 here represents a year before 1900 i.e 1899
Not really. It's precisely 1 day before the first day of 1900. Yes, it occurs in 1899 but...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 19, 2011 at 8:30 pm
Viewing 15 posts - 33,556 through 33,570 (of 59,102 total)