Forum Replies Created
Viewing 15 posts - 3,931 through 3,945 (of 5,356 total)
-
RE: Generate SQl Script
Hi Manie,
quote:
I would like to generate a SQL script of an object with a SQL script. Is it possible or is it... -
RE: Do you allow developer to access Production Server
quote:
The main point is why would developers have a 'domain admin' account, and in andoi case they are giving themselves permissions where... -
RE: Do you allow developer to access Production Server
quote:
To stop NT admins playing with my sql servers I remove the builtin/administrator from the sql admin group, hence they can't change... -
RE: How to run dynamic SQL with IF EXISTS?
quote:
From my understanding and what I remember from other threads on this site, you are correct. IF EXISTS will stop at the... -
RE: What did you do before SQL?
quote:
I wonder if you would consider this 'vanilla'?Computer Studies at secondary school
Computing at high school
Computing at college
First job Project Office Clerk (IT)
Trainee...
-
RE: What did you do before SQL?
quote:
And before that, I was a barman in a rugby club, and a nachtportier in an Austrian ski resort.September 11, 2003 at 2:22 am
-
RE: A Brief History of SQL
quote:
Well get to work already, what else have you got to do that is more important
-
RE: Performing aggregate calculations on null values
Stupid, stupid Frank
Forget my last post.
AVG already does this for you!
Frank
-
RE: Do you allow developer to access Production Server
quote:
NEVER. Simple as that.Agreed with that!
Would certainly be a great issue at the...
-
RE: Execution Plans
quote:
Ok. Thanks for your help anyway. What I don't understand is why SQL Server should decide to use different execution... -
RE: Performing aggregate calculations on null values
quote:
The AVG function will ignore NULL values in its calculation and provide a warning that NULL value is eliminated. You could test... -
RE: Table Order!
Hi Matthew ,
ok, unfortunately the following is not my own!
Taken from Inside SQL Server 7 (sorry, the one I got at home) Part IV Chapter 14
'Optimizing Queries'
...
For the most common...
-
RE: A Brief History of SQL
Hi cppwiz, hi phillcart,
are you mind-readers?
Btw, I think I have read something of a company called Sybase, but I can't really remember right now
Anyway, something...
-
RE: Table Order!
I think I read somewhere in InsideSQL Server a passage where is states, as a rule of thumb you should not Join more than 4 tables. Otherwise you lose performance.
Will...
-
RE: Easy way to truncate multiple tables in SS 2000
Well, after a little bit longer.
Hm, when the table(s) you want to do this for hardly never change, why not use Allen suggestion, create a stored procedure, and customize in...
Viewing 15 posts - 3,931 through 3,945 (of 5,356 total)