Forum Replies Created

Viewing 15 posts - 286 through 300 (of 628 total)

  • RE: The NONUpgrade from 2005

    yeah I had read that previously but I was hoping for something more helpful than there advice to manually move everything on the server.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Getting started with SSRS

    I actually have a hard time getting locahost to work as well. I have never really devoted any time to figuring out why since you should be able to...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Getting started with SSRS

    If you have run the configuration and you were able to get it connected then SSRS is installed. BIDS is just a version of visual studios. you should now...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Getting started with SSRS

    If you look under the configuration folder do you see something that says reporting services configuration manager?

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: generate insert statements with data

    If you want to grab a SQL insert statment you would do something like the following.

    Let say you have table A and there are records in in like col1 and...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: quick question on viewing data.

    create your first dataset and then use a pivot table

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: The given value of type String from the data source cannot be converted to type bigint of the specified target column.

    Hey who starred in that movie last year you know the one with the guy that liked the girl?

    Provide some more information and we will be happy to assist where...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Getting started with SSRS

    during the install you have to select reporting services. After the install you have to setup the reporting server. This is a pretty large topic to cover but...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Math function question

    Here is a link to an article I read some time back that has some pretty decent information on the subject.

    http://sqlblog.com/blogs/aaron_bertrand/archive/2008/04/27/performance-storage-comparisons-money-vs-decimal.aspx

    What the autor hints at though is that...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Filter suppliers that dindn't sell

    try this. The problem comes from the fact that fan01 does not physically exist it is a named output of the query.

    select t.* from

    (

    SELECT

    fc.no, fc.nome,

    ...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Remote Backup

    this is a kind of hokey way to do it but I have done this in other scenarios where I needs to do a similiar function. create a SP...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Steps needed to follow to restore Master database and other system databases.

    The steps are basically.

    Stop the service

    enter the -m and start the service in single user mode

    stop the service

    remove the -m

    start service normally.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Find Current CPU Usage- Find the SQl using most of CPU

    I would highly recommnd installing the performance dashboard from Microsoft if you have not already. you could easily see all the information you need from there.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Steps needed to follow to restore Master database and other system databases.

    here is a link to an msdn page with step to restore the master database. basically you have to put the database in single user mode and then it...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • RE: Talking baseball

    watching the clip I am not sure the first baseman ever expected that throw. he seemed very out of position for a pickoff attempt. It makes me wonder...

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

Viewing 15 posts - 286 through 300 (of 628 total)