Viewing 15 posts - 4,726 through 4,740 (of 7,505 total)
you can view the partitioned objects using these queries:
USE [DPartitioning]
/*
show partitioned objects
*/
select distinct
p.[object_id],
TbName = OBJECT_NAME(p.[object_id]),
index_name = i.[name],
...
July 9, 2008 at 2:08 pm
IMO you are turning your cat inside out.:ermm:
If you stick to this bad design, your queries will not perform well !!
resulting in slow applications and over utilised servers.
If you install...
July 9, 2008 at 6:31 am
be sure to include the objects schema ! (even if it is dbo)
don't use reserved words in your objects or always use brackets !
In your case it was object "user"...
July 9, 2008 at 5:47 am
Be sure to point to the correct filelocations !
(and they must be reachable for the sqlserver service account !!)
July 9, 2008 at 5:38 am
IMHO your clientidS column is a prove of bad design ! (one column containing a bunch of seperate dataitems)
Check out "normalization" at SSC.
You cannot execute a sproc in a...
July 9, 2008 at 5:36 am
just to add to Gails reply..
be sure to provide indexes that match your FK-declaration !
(because otherwise you 'll end up with dependant table scans !!)
July 9, 2008 at 5:27 am
It's been a while, but I've seen a solution for mainframe db2 where you could prepare a full set of (related) data to be loaded into an environment.
I cannot...
July 8, 2008 at 12:01 am
just a little remark:
avoid using left and right outer joins together.
Choose one and go with that. (I prefer left join because then you're result is formed from top to...
July 5, 2008 at 6:24 am
many thanks for this usefull proc.
All I needed to add is a @Versions2Keep parameter.
July 4, 2008 at 7:12 am
It seems is going to be a cosy SSC-evening at SQLPass this year,
and by now Steve will have gotten the picture for the SSC-T 208:
front: upper left: SQLServercentral.com and the...
July 4, 2008 at 12:16 am
Congratulations Jeff and Michael.
A virtual pint to your honor ! (maybe we'll materialize that at SQLPass 😀 )
July 2, 2008 at 5:17 am
Check RETURN in bol !
Return is not used to fillup output variables, but it gives an integer value to the calling object. (mostly used to indicate OK or not OK)
To...
July 1, 2008 at 1:22 am
Steve Jones - Editor (6/30/2008)
We implemented Dynamics about 8 years ago and they said they required SA to run the application. I dug...
July 1, 2008 at 12:20 am
And keep in mind that sql2005 may work better if the dblevel is put to 90. (=sql2005) Afterward you can put it back to 80 if needed !
The upgrade path...
June 30, 2008 at 8:17 am
Viewing 15 posts - 4,726 through 4,740 (of 7,505 total)