Viewing 15 posts - 8,041 through 8,055 (of 19,560 total)
sqlquest2575 (11/2/2011)
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
November 3, 2011 at 8:24 am
I skipped right over that Declare + Set and the fact that it was for 2005 and up since I had been doing that kind of set for some time...
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
November 3, 2011 at 8:21 am
Ray K (11/3/2011)
overwhelmed
overweight
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
November 3, 2011 at 8:13 am
The failed to login sounds like the domain account being used to login wasn't able to talk to AD (assuming AD is involved). That seems to be a highly...
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
November 2, 2011 at 5:09 pm
Are you running that combination of queries direct on the server in SSMS? Or are you running it from your desktop?
If direct on the server, you have the memory...
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
November 2, 2011 at 5:03 pm
It looks like it may be too many queries and memory on your local machine is inadequate for the extreme number of queries and exec plans.
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
November 2, 2011 at 4:54 pm
codebyo (11/2/2011)
I'm trying to make an example but I'm not being successful because I'm not experience in using that technique.
Perhaps someone more...
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
November 2, 2011 at 4:51 pm
L' Eomot Inversé (11/2/2011)
SQLRNNR (11/2/2011)
L' Eomot Inversé (11/2/2011)
SQLRNNR (11/1/2011)
RameumptomZoramite
Google?
No. I owe my recognition of the word to my ability and willingness, when I was young and foolish, to offend...
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
November 2, 2011 at 4:45 pm
elkucho (11/2/2011)
So if the records doesn't exist it will do to a OLD DB Destination, right ?
But if it does exist, what is the next component after...
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
November 2, 2011 at 3:31 pm
Dave Mason (11/2/2011)
Elliott Whitlow (11/2/2011)
You are asking for trouble...CEWII
Why? Can you give me some specifics?
I think he was understanding you to say restore the database from 2005 to 2008....
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
November 2, 2011 at 3:09 pm
That means that the RDL files were upgraded to the 2008 version and cannot / will not work in 2005. You should use VS 2005 to edit modify SSRS...
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
November 2, 2011 at 3:08 pm
An alternative that would work well would be to stage that data into a "temp" table and then use the merge statement.
Otherwise, what Lynn provided should work.
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
November 2, 2011 at 2:55 pm
You will need to specify the number of decimal places unless you convert to a float type. If you convert to Int - there will be 0 decimal places.
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
November 2, 2011 at 2:11 pm
As Jared said - we need a lot more info to answer that question. The reporting server needs to be built according to your reporting requirements.
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
November 2, 2011 at 1:47 pm
If the databases are at the same version, it is feasible.
However, I prefer to restore the database as a different database name, then import the data that I need.
Or I...
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
November 2, 2011 at 1:35 pm
Viewing 15 posts - 8,041 through 8,055 (of 19,560 total)