Viewing 15 posts - 451 through 465 (of 2,647 total)
So how do you release new production databases?
July 19, 2012 at 8:24 am
How exactly are you trying to connect (what are you typing in for server name)? Is it a default or named instance?
July 19, 2012 at 8:21 am
base table C has (let's say) 100 rows.
If any of the identifying fields in base table c do not match with the table it is joined to, you will get...
July 19, 2012 at 8:10 am
Is SQL Server Browser running? How exactly are you trying to connect (what are you typing in for server name)? Is it a default or named instance? Do you...
July 19, 2012 at 8:01 am
yogi123 (7/18/2012)
SQLKnowItAll (7/18/2012)
July 18, 2012 at 1:28 pm
Take a look at this blog post. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
July 18, 2012 at 1:25 pm
Can I ask why you want your results like that from a query? Are you going to be having the end users run this in SSMS or at the...
July 18, 2012 at 1:23 pm
Jeff Moden (7/18/2012)
I believe you quoted the wrong post.
Doh! (or should I say Bwaa ha ha!) This site certainly does some crazy things when you reply and others are posting......
July 18, 2012 at 12:32 pm
lokeshvij (7/18/2012)
better way optimize for modulo 10 would be to use RIGHT function.RIGHT(value,1) -- check if this helps
Hmm... Nope. SELECT .09 % 10
July 18, 2012 at 12:02 pm
Its not that it doesn't, its that you don't know when it will or won't becasue it is up to the optiizer to choose the best execution plan. I...
July 18, 2012 at 10:31 am
Thanks Jasmine. This is just for Customer Service and QA to do quick data checks, so should be good.
July 18, 2012 at 10:07 am
A constraint is a unique index.
You can do it in your create table statement: CREATE TABLE accountBalance (accountNo BIGINT PRIMARY KEY --CLUSTERED or NONCLUSTERED
, accountBalance)
You can...
July 18, 2012 at 9:59 am
Ok many thanks for all the contributions.
So. I think we are down to the following options :
1. Use Locks during the update with also a constraints rule
or
2. Have a 'Constraint...
July 18, 2012 at 9:55 am
Jasmine D. Adamson (7/18/2012)
GilaMonster (7/17/2012)
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
And to toss fuel on the fire, several of the query patterns mentioned in this thread would cause all sorts of hell when the plans are...
July 18, 2012 at 9:43 am
patrickmcginnis59 (7/18/2012)
gerard-593414 (7/18/2012)
But I dont understand how the database Engine will prevent (without additional error checking or rules) TWO ACCOUNTS WITH THE SAME NUMBER BEING ADDED. Two...
July 18, 2012 at 8:58 am
Viewing 15 posts - 451 through 465 (of 2,647 total)