Viewing 15 posts - 9,136 through 9,150 (of 19,560 total)
Nice question. I hadn't considered the heap compression behavior before - it is good to know that too.
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
August 9, 2011 at 9:56 am
bopeavy (8/9/2011)
Revenant (8/9/2011)
bopeavy (8/9/2011)
--------------------------------------------------------------------------------
Ray K (8/9/2011)
--------------------------------------------------------------------------------
Daniel Bowlin (8/9/2011)
--------------------------------------------------------------------------------
bopeavy (8/8/2011)
--------------------------------------------------------------------------------
Target
bullseye
Sheriff Woody
Blazing Saddles
spoof
Space Balls
Schwartz
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
August 9, 2011 at 9:48 am
In the thread at http://www.sqlservercentral.com/Forums/Topic1156433-148-1.aspx#bm1156467
you said:
kishoremania (8/8/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
August 8, 2011 at 4:31 pm
Just curious - why?
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
August 8, 2011 at 4:05 pm
But you are able to populate the other two tables?
Are you using a sql query in your SSIS package to determine the population of these tables?
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
August 8, 2011 at 4:04 pm
Where are you getting stuck?
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
August 8, 2011 at 3:35 pm
Grant Fritchey (8/8/2011)
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/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
August 8, 2011 at 2:31 pm
Are all databases being restored to a server that is the same version as the 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
August 8, 2011 at 2:30 pm
What is the error?
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
August 8, 2011 at 2:23 pm
I think the better solution is the normalized database with SSRS. I would not do it in Access.
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
August 8, 2011 at 2:17 pm
is the service stopped?
Are you getting errors?
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
August 8, 2011 at 2:11 pm
Might as well plug the tools from RedGate as well. SQL Compare and SQL Data Compare.
One more option would be via RedGate Virtual Restore (where you could just restore...
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
August 8, 2011 at 1:23 pm
Several options exist.
First, do you have the table structure already on the target server? Are you just trying to copy the data?
Knowing the scope of this table copy will...
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
August 8, 2011 at 1:18 pm
GilaMonster (8/8/2011)
GSquared (8/8/2011)
Grant Fritchey (8/8/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
August 8, 2011 at 1:14 pm
Grant Fritchey (8/8/2011)
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/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
August 8, 2011 at 12:42 pm
Viewing 15 posts - 9,136 through 9,150 (of 19,560 total)