Viewing 15 posts - 196 through 210 (of 820 total)
So here is a couple of questions.
Let's say that there is a tool that lets you:
Log into a SQL server.
Update the description extended properties on your tables and columns.
Lets you...
March 17, 2011 at 12:40 pm
zebulonpi (2/15/2011)
Also, when publishing something intended as educational, AND being reviewed by your peers, you WILL get criticism. Take it as constructive, learn from it, and become better.
Which was exactly...
February 15, 2011 at 9:57 am
First I think that the intent, target, and scope are great. Yes, there is room for revision.
Nice effort, Ron. Everybody gets the blowtorch to the backside for everything...
February 15, 2011 at 9:30 am
Please take into consideration those of us with chronic sinus conditions. I remember as an operator being seated in front of the console and having a large attack. ...
February 8, 2011 at 2:56 pm
GilaMonster (1/21/2011)
A table can be a heap and have a pk. It can have a clustered index without a pk. Primary key != clustered index.
Here is a point that is...
January 21, 2011 at 10:52 am
Points made by Thomas-282729 and others are valid for consideration. You have to apply all of these through a filter of sense. The other point that was...
January 3, 2011 at 10:53 am
Wonderful article. Good job. A couple of points though.
For the online kind of storage you are right, and right on the mark. Still the "disk is cheep"...
December 31, 2010 at 10:56 am
dforck (12/31/2010)
December 31, 2010 at 10:42 am
jcrawf02 (12/28/2010)
"and then go home and get on with out lives"
maybe somewhere there's ONE of us who...
December 28, 2010 at 9:45 am
A friend of mine had 5 in the house and 32 in the yards. He also had chickens, geese, a swan, and pot bellied pigs. We started calling...
December 28, 2010 at 9:26 am
"I'm Steve Jones ... and this is a cat!" ROFLMAO! I have one now but had two for quite a while. They will make one laugh when...
December 26, 2010 at 2:24 pm
Running a query across multiple servers in a group.
Filtered Indexes. Makes up for a crappy design that I inheirited and can't (yet) rewrite.
Intellisense. I plan on adding the...
December 17, 2010 at 8:22 am
Here is how to drop the time from a date/time. I use GetDate() in the example but you can use a column just as well.
SELECT DATEADD(DAY, 0, DATEDIFF(DAY, 0,...
November 17, 2010 at 3:18 pm
Viewing 15 posts - 196 through 210 (of 820 total)