Viewing 15 posts - 1 through 15 (of 98 total)
Firstly, I'll belatedly add my congratulations for a clear and concise article. It was well written and explained the intent despite the misleading title about the where clause rather than...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
January 30, 2011 at 5:04 pm
hilld (1/25/2011)
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
January 25, 2011 at 7:37 am
GilaMonster (1/25/2011)
jts_2003 (1/25/2011)
What would be great is an easy way of backing up (and restoring) just a table... maybe in Denali?
No, and I doubt it will ever be a native...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
January 25, 2011 at 4:49 am
carlos.ramon.martinez (1/25/2011)
Hello,just to finish undestanding, I would like to know in which cases @@rowcount can be greater than the number of rows. If anybody could explain I would appreciate.
Kind regards
Rowcount...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
January 25, 2011 at 4:35 am
opc.three (8/31/2010)
Rob Fisk (8/31/2010)
opc.three (8/31/2010)
Rob Fisk (8/31/2010)
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
August 31, 2010 at 7:24 am
opc.three (8/31/2010)
Rob Fisk (8/31/2010)
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
August 31, 2010 at 6:48 am
I didn't use ISNULL or COALESCE becuase i defaulted the parameters to '' instead of null to remove the need.
Of course you have to ensure that the front end either...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
August 31, 2010 at 4:21 am
Very good points at the start of the article and I may do some refresher readin on some bits but for the specific example would something like this not be...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
August 31, 2010 at 3:02 am
sidni (7/2/2010)
Is there a way I can run the procedure from other databases on the same server without having to copy into each database I want to run it on.Thanks
s
Yes,...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
July 2, 2010 at 12:22 pm
sidni (6/30/2010)
Igore my previous post, just figured it out. Great work.Thanks
sidni
Sorry, missed the original question so have not investigated. Since you have worked it out then an explanation of the...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
July 1, 2010 at 10:43 pm
Fantastic article. Made me want to go look at it (just for the learning experience since we are a small place and don't suffer from load issues-- yet).
Unfortunaltely due to...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
June 29, 2010 at 6:08 am
I normally just create a very restriced access share on the DB machine so I can grab the files off it remotely. I find that with SQL server it's a...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
June 18, 2010 at 8:22 am
christopher.cormier (6/9/2010)
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
June 9, 2010 at 8:18 am
To some extent I agree.
There is no need to have CustomerName in the Customer table but with columns such as ID I would never rely just on that. I would...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
June 8, 2010 at 4:30 am
I did touch on that subject that in http://www.sqlservercentral.com/Forums/FindPost928963.aspx
Generally authenticated users can relay and setting up the profile to use authentication is fairly straightforward as I remember.
For my profile I...
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
June 3, 2010 at 7:31 am
Viewing 15 posts - 1 through 15 (of 98 total)