Viewing 15 posts - 3,241 through 3,255 (of 7,187 total)
Whether anyone thinks it's arrogant or controlling or what have
I only said it's arrogant to tell someone that you don't know and whose environment and circumstances you don't know that...
January 21, 2015 at 9:49 am
Yes, I'm the DBA here and Hungarian notation does not form part of our standards. But I'm not the DBA everywhere, and I'm not arrogant enough to suggest that...
January 21, 2015 at 8:17 am
I suppose it depends on your data. You'd have to put the columns in questions into separate tables, which would require changes to your database schema and your code....
January 21, 2015 at 2:43 am
Jeff Moden (1/20/2015)
John Mitchell-245523 (1/15/2015)
SQLvis (1/15/2015)
Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?
Not really. It's more important...
January 21, 2015 at 2:06 am
Do you mean varchar(max) and nvarchar(max) columns? Where did you read that it's best to separate them, and how would you propose to do it?
John
January 20, 2015 at 5:35 am
Those columns don't have maximum lengths. They can be as long as the data in them. Probably best to sum up the lengths for all the columns that...
January 20, 2015 at 5:28 am
No, I mean please show us the actual query you've tried. And if you also supply the table DDL and sample data in the form of CREATE TABLE and...
January 20, 2015 at 5:01 am
The allow updates option doesn't have any effect any more (from SQL Server 2005). You could use a trigger instead of a constraint in order to return the error...
January 20, 2015 at 4:40 am
It's just a simple join you need, isn't it? Please will you show us what you've already tried, so that we can show you where you're going wrong?
John
January 20, 2015 at 4:35 am
You see where it says "Operating system error = 32"? If you don't know what that error code means, go to a command prompt and type [font="Courier New"]net helpmsg...
January 15, 2015 at 7:50 am
SQLvis (1/15/2015)
Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?
Not really. It's more important to have a convention...
January 15, 2015 at 5:10 am
Type those very words into your favourite search engine. You'll get plenty of results.
John
January 15, 2015 at 4:56 am
Baiju
Try enclosing your parameter list in parentheses.
John
January 15, 2015 at 4:38 am
Vaidy Mohan (1/15/2015)
Is there a compelling reason as to why we should not be writing procedures with "sp_" prefix?
"sp_" is the prefix used for system stored procedures, so there are...
January 15, 2015 at 3:54 am
If I remember correctly, the job will still run in the context of the SQL Server Agent service account if the job owner is a member of sysadmin. Is...
January 14, 2015 at 8:55 am
Viewing 15 posts - 3,241 through 3,255 (of 7,187 total)