Viewing 15 posts - 226 through 240 (of 392 total)
Sorry, this is not a very good question. I got it right, only because I assumed that the writer of the QOD meant to infer that there is a wizard...
December 3, 2010 at 5:57 am
SanDroid, I was wondering when you were going to show up;-)
(I need to get mine back as well:hehe:)
December 2, 2010 at 2:27 pm
Jeff
Many languages, when they compile the code, strip out comments as wasted space.
Agreed - but these are not comiled apps. Before you say it, I know that many HTML generators...
December 2, 2010 at 8:36 am
Good question - thought about it until it hurt:hehe:
Why would you want to use a where clause to enforce uniqueness? That one stumps me. Otherwise, I agree with the rest...
December 2, 2010 at 7:26 am
Tom
Another reason not to use sys.syscomments and use sys.sql_modules instead (the type of the definition column of sys.sql_modules is nvarchar(max)).
This isn't what the question is. Additionally, maybe if the question...
December 2, 2010 at 6:52 am
Imran
Northwind is normally associated with SQL Server 2000 and below.
Unless you performed an upgrade from 2000, in which case the database would be upgraded to the next version as well.
December 2, 2010 at 6:42 am
Good question, and actually makes one think a little.
Tom
If you've never seen any comments in there I don't want you writing any stored procedures or triggers in my shop!
Kind...
December 1, 2010 at 6:48 am
Is the startup service of all of your SQL Servers the same and are they Domain Admin?
What is the permission level of the account calling the stored procedure?
November 30, 2010 at 5:32 am
We have the same issue, rougly 80 servers on the network, and each needs to be able to pass data to the HQ.
What we do - declare a variable for...
November 29, 2010 at 7:29 am
Mike, good question. I guessed at the answer and learned something new.
Thanks
November 23, 2010 at 8:34 am
Fat Wallet
From the perspective of a professional DBA and Dev, this is useless. First, it is troublesome. Second, it cannot guarantee pulling data correctly. Third, it does not give enough...
November 23, 2010 at 8:24 am
Sarvesh, This was a good article, with the potential to be much better if you were to expand on it. You leave out a lot of why things work this...
November 23, 2010 at 6:16 am
Excellent question on a topic which is such a problem. I see this a lot from developers who wonder why it won't work. At first glance, it looks like it...
November 18, 2010 at 6:24 am
Excellent question - got it wrong but learned something new. It's going to be a great day:hehe:
November 17, 2010 at 5:41 am
Everyone seems to think that if one throws a big collection of disks at this and then uses virtual raid it will meet the IO requirements, I am not too...
November 16, 2010 at 7:50 am
Viewing 15 posts - 226 through 240 (of 392 total)