Viewing 15 posts - 7,156 through 7,170 (of 18,926 total)
I've always kept the FKs, tho I've seen systems work well without 'em (microsoft application).
When you use the diagrams of SMSS, the FK will allow you to see the relations...
February 8, 2011 at 3:08 pm
Svs2010 (2/8/2011)
February 8, 2011 at 3:05 pm
Yes you're right on the script part.
Like I said I NEVER leave the keys out of the dev phase.
And then I'm good enough at tuning that I don't need to...
February 8, 2011 at 12:05 pm
Grant Fritchey (2/8/2011)
ericwenger1 (2/8/2011)
February 8, 2011 at 12:03 pm
CirquedeSQLeil (2/8/2011)
homebrew01 (2/2/2011)
No one has mentioned this method:select * from tableA
then scroll down to the bottom to see how many rows there are
:Whistling::w00t::hehe::-D
Evil :-D:w00t::hehe:
I'd just do SELECT * FROM dbo.TblA...
February 8, 2011 at 12:01 pm
Well now just to add to that list, you need to make sure the sql 7,8,9 dbs will work on 2008 R2 (assuming you buy the latest version of sql...
February 8, 2011 at 12:00 pm
What I meant is that I can't simply copy and paste the script you provided. It would fail because the 2nd create table happens after you try to build...
February 8, 2011 at 11:57 am
sqlgreenhand (2/5/2011)
February 8, 2011 at 11:55 am
Steve Jones - SSC Editor (2/8/2011)
I tend to use FQDNs rather than client side aliases. So if I had cognos, Sharepoint, and ERP applications, I'd setup.
-...
February 8, 2011 at 11:52 am
Nothing wrong with that. I guess you simply forgot the index on Countryid in the usersinfo table.
Also, the script in that sequense qill not work, so maybe we are...
February 8, 2011 at 11:48 am
Krasavita (2/8/2011)
I can't specify there where my backups
What do you mean???
Yes you can provide a root folder. And then you have a option for recursive delete for all the...
February 8, 2011 at 11:37 am
zubairmasoodi (2/8/2011)
but Logically speaking , Dont you think its wrong that it will not allow me to delete a record in UserInfo Table
Country Table is Master Table, I am not...
February 8, 2011 at 11:34 am
It only has to be a key in the countries table, not the other way around.
February 8, 2011 at 11:33 am
And just to point out something else. You will be able to delete, but not TRUNCATE. The fk removes the ability to truncate, but that's all.
February 8, 2011 at 11:23 am
zubairmasoodi (2/8/2011)
I quote you
"2 Improves db speed" and this is my primary motivation., but i wonder architecturally if its a good practice.
Limitation here i see...
February 8, 2011 at 11:22 am
Viewing 15 posts - 7,156 through 7,170 (of 18,926 total)