Viewing 15 posts - 1,741 through 1,755 (of 7,502 total)
Fal (8/22/2011)
Dwayne Dibley (8/22/2011)
August 23, 2011 at 2:26 am
GilaMonster (8/21/2011)
ALZDBA (8/21/2011)
It is a first step and IMHO a good one to work on experience with the topology and science of when and how to split data and indexes.
Depends.
There...
August 21, 2011 at 10:53 am
GilaMonster (8/21/2011)
To pull that off and have it show performance improvements you need to do a lot more thought and a lot more design than just 'tables on filegroup 1,...
August 21, 2011 at 8:29 am
john-902052 (8/20/2011)
I have a question if you wouldn't mind.
I have a db Cases with an Identity column CaseID and I have a few other dbs that store the CaseID....
August 20, 2011 at 11:02 pm
As it was mention that "It is pointless posting the query here - the view has 42 joins and many of those are other views (I know - don't ask...
August 20, 2011 at 1:50 pm
Here are come SSC articles that can help out.
http://www.sqlservercentral.com/search/?q=move+index+filegroup&t=a&t=s
August 20, 2011 at 6:39 am
Lynn Pettis (8/19/2011)
.... I am really looking forward to getting back to what I know and love in the databasse world.
Welcome back in our SQLServer universe, Lynn.
All the best on...
August 20, 2011 at 2:24 am
Ninja's_RGR'us (8/19/2011)
WayneS (8/19/2011)
Ninja's_RGR'us (8/19/2011)
August 19, 2011 at 8:14 am
SqlSpider... (8/19/2011)
In TableB i have to set a foreign key for the column 'num'
I was given like this:-
create...
August 19, 2011 at 7:46 am
WayneS (8/18/2011)
Steve Jones - SSC Editor (8/18/2011)
August 19, 2011 at 1:30 am
Thank you for the feedback. :smooooth:
I've been looking for such kind of bug info for your thread, but apparently did google/bing the wrong key words :crazy:
It seems to be spot...
August 19, 2011 at 1:17 am
First question: What are you trying to accomplish using the id+num column combination ?
( Why not only the id column as pk and an uk on num+id ?)
A foreign key...
August 19, 2011 at 12:52 am
Jim Murphy (8/18/2011)
ALZDBA (8/18/2011)
One precon to attend on Monday, one precon to attend on Tuesday, 3 days con .... to be expected oct 10-14 :w00t::w00t::w00t:
Hahahaha. Great chuckle. Thanks.
Say, I...
August 18, 2011 at 8:37 am
Steve Jones - SSC Editor (8/18/2011)
August 18, 2011 at 8:32 am
Grant Fritchey (8/18/2011)
GilaMonster (8/18/2011)
Jim Murphy (8/18/2011)
August 18, 2011 at 5:56 am
Viewing 15 posts - 1,741 through 1,755 (of 7,502 total)