Viewing 11 posts - 16 through 27 (of 27 total)
I would do the following, create a sql string then execute that once it is built - example:
create PROCEDURE dbo.test
@ListOwner varchar(200),
@Roles varchar(2000)
AS
/*...
** What you see, Depends on what you Thought, Before, You looked! **
December 29, 2006 at 7:25 am
Wow ! - I was looking for all this information a while back and never found as much detail as you had managed within the couple of links you had...
** What you see, Depends on what you Thought, Before, You looked! **
December 28, 2006 at 7:26 am
I am not sure of the function of your application, but is it worth having several tables that are date related and then just drop the tables that are relevent...
** What you see, Depends on what you Thought, Before, You looked! **
December 14, 2006 at 7:57 am
Grats on hitting that mark - Just interested , is this a data warehouse database as opposed to an OLTP one ?
** What you see, Depends on what you Thought, Before, You looked! **
December 14, 2006 at 7:46 am
What are the performance and logging implications if the index were to be deleted and recreated - as opposed to defragging? I know that access to the table may be...
** What you see, Depends on what you Thought, Before, You looked! **
December 14, 2006 at 7:36 am
I would be vey interested to know how you implemented your cluster solution form an architectural point of view, and what configuration it is in (ie a/a or a/p). I...
** What you see, Depends on what you Thought, Before, You looked! **
November 22, 2006 at 11:18 am
Here are a couple of links that may help you navigate your way through the clustering side - I have been working on a similar scenario and there are certainly...
** What you see, Depends on what you Thought, Before, You looked! **
November 22, 2006 at 7:05 am
This may not be much help and is more of a backend solution rather than controlled in the reporting services output. when performing the select do something like SELECT TOP...
** What you see, Depends on what you Thought, Before, You looked! **
November 21, 2006 at 7:11 am
Well as no-one else has answered here yet - I will add a few things I would look for during a load test.
Does the load affect any other users on...
** What you see, Depends on what you Thought, Before, You looked! **
November 15, 2006 at 7:15 am
I have done more research on the location of the Tempdb and it appears there are several recommendations for the area to be located on the shared resources, but none...
** What you see, Depends on what you Thought, Before, You looked! **
November 15, 2006 at 6:54 am
Thank for your reply - It has raised more questions so here goes.
Can you explain a bit better why you recommend that the tempdb reside on the shared resources of...
** What you see, Depends on what you Thought, Before, You looked! **
November 10, 2006 at 7:33 am
Viewing 11 posts - 16 through 27 (of 27 total)