Viewing 15 posts - 7,156 through 7,170 (of 18,923 total)
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
Steve Jones - SSC Editor (2/8/2011)
The load, as mentioned, is something I'd be careful of, and...
February 8, 2011 at 11:20 am
Craig Farrell (2/8/2011)
Ninja's_RGR'us (2/8/2011)
That explains your avatar SO WELL.
:laugh: The fact that it's usually silly or the fact that it doesn't ever seem to be the same one 3...
February 8, 2011 at 11:11 am
I've seen it work both ways.
Both have advantages that are no negligible. 1 garantees the data is good. 2 Improves db speed.
What would you do ?
February 8, 2011 at 11:07 am
Viewing 15 posts - 7,156 through 7,170 (of 18,923 total)