Viewing 15 posts - 6,676 through 6,690 (of 19,560 total)
Oh. I didn't know you were trying to move multiple databases into a single database. That wasn't mentioned previously.
If you are trying to build a mechanism to sync...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 1:56 pm
Good.
With reports that have parameters, I tend to code for parameter sniffing as a precaution. I have run into this problem too often with reports.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 1:53 pm
Create the time column with a default constraint for your timestamp.
You can't mix the select and Exec in the insert statement like that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 1:52 pm
Lynn Pettis (3/22/2012)
What do you test your code on during development? You don't have a development or test database to work with?
Even taking the DDL from the dev/test server...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 1:51 pm
The stored proc is expecting the report to pass a parameter that you are not passing. Add a parameter, then add that parameter to the proc data source.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 1:45 pm
As Daniel said, this sounds like parameter sniffing. Fixing for that should help.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 9:53 am
You possibly have another parameter that is dependent on that parameter.
Or, do you have any subreports that may have that parameter?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 8:52 am
anthony.green (3/22/2012)
hackneyed
blackndeye:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 8:50 am
straight forward except the small typo.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 22, 2012 at 7:13 am
L' Eomot Inversé (3/21/2012)
SQLRNNR (3/21/2012)
spectaclecyclops
monocle
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 21, 2012 at 5:56 pm
Have you checked the tooltip property on tablix1?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 21, 2012 at 12:30 pm
Another option is to use CMS.
You can deploy a script to an entire set of servers at once that way.
I have seen some places develop there own deployment tool via...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 21, 2012 at 12:28 pm
Verify that you are trying to copy the correct data files for the database you detached. If the files are correct, then verify the permissions on the files individually.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 21, 2012 at 12:08 pm
Using SSIS to move the data or the Data import can do it for you.
Alternatively, you could backup the databases and restore to a 2005/2008 server first - upgrade the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 21, 2012 at 12:05 pm
crookj (3/21/2012)
Brandie Tarvin (3/21/2012)
Ray K (3/21/2012)
crookj (3/21/2012)
WOTD - Instigatorperpetrator
crime
Fighter
Fire
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 21, 2012 at 11:51 am
Viewing 15 posts - 6,676 through 6,690 (of 19,560 total)