Viewing 15 posts - 5,911 through 5,925 (of 19,560 total)
Same syntax as an insert into a table that is not compressed. The CPU cost is minimal.
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
July 23, 2012 at 5:37 pm
What driver are you using to connect to the informix database?
See if this article is of help.
http://jasonbrimhall.info/2010/07/23/a-little-dance-with-ssis-and-informix/
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
July 23, 2012 at 3:29 pm
capn.hector (7/23/2012)
Dumb Phones
moroff phones:hehe:
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
July 23, 2012 at 3:26 pm
Just grant them access to the Dev instance on the server rather than RDP. Then install management tools on their desktops and allow them to use SSMS to connect...
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
July 23, 2012 at 11:11 am
Seems very similar to another we had recently.
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
July 23, 2012 at 9:49 am
C6H12O6
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
July 23, 2012 at 9:20 am
opc.three (7/21/2012)
Have you evaluated Merge Replication?
Merge would be far better than SSIS for this.
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
July 21, 2012 at 8:12 pm
Kingston Dhasian (7/20/2012)
The below article by Wayne Sheffield might be of help to youComparing Table Variables with Temporary Tables
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
+1. Good reference
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
July 21, 2012 at 7:07 pm
A lower page fill can lead to improved performance.
High transaction, I might test as low as 70% fill factor but would be very cautious about it. You will need...
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
July 20, 2012 at 9:53 pm
It's still there in 32 bit versions just not 64 bit Standard. I agree that it makes no sense.
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
July 20, 2012 at 1:34 pm
Correct, it is not available in 64 bit versions
http://msdn.microsoft.com/en-us/library/cc645993.aspx
Maybe stand up a 32 bit version, use SSIS, or use Enterprise edition.
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
July 20, 2012 at 1:26 pm
In addition, there are several good books you can get that will step you through various tasks.
One such is coming out next month
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
July 20, 2012 at 11:55 am
Pension
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
July 20, 2012 at 11:12 am
WayneS (7/19/2012)
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
July 20, 2012 at 9:36 am
BenWard (7/19/2012)
paul.knibbs (7/19/2012)
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
July 19, 2012 at 3:23 pm
Viewing 15 posts - 5,911 through 5,925 (of 19,560 total)