Viewing 15 posts - 5,926 through 5,940 (of 7,168 total)
Pam Brisjar (6/22/2011)
I suspect there's a security context difference between running a SQL Agent job via...
June 22, 2011 at 9:17 am
.NET class System.Data.SqlClient.SqlBulkCopy
It allows one to load data directly from an ADO.NET data structure into a SQL Server database via the bulk copy API (same one used by bcp I...
June 22, 2011 at 9:10 am
Yes there are certainly ways. SSIS error handling and logging is robust but I have found the bar to be high to get a simple solution in place...which I guess...
June 22, 2011 at 8:55 am
Jeff Moden (6/21/2011)
June 22, 2011 at 7:42 am
opc.three (6/21/2011)
Yes it can be done using a Cross Tab Query or the PIVOT operator.
The fact that they are aggregations is a distraction. Concentrate on the shape of the resultset,...
June 22, 2011 at 7:30 am
GilaMonster (6/22/2011)
Both of them.
🙂
June 22, 2011 at 6:40 am
Knowledge Hunter (6/21/2011)
June 22, 2011 at 6:38 am
Not a picture...please provide the actual execution plan saved as a .sqlplan file.
June 22, 2011 at 6:05 am
Craig Farrell (6/22/2011)
Yeeps, sorry Orlando, I fear you may have taken me the wrong way. I meant to add to your commentary, not abuse it. Apologies.
No...
June 22, 2011 at 5:59 am
Craig Farrell (6/22/2011)
For anyone following along with the Level II masquerading as a III, here's my next hint for research:
With Sommarskog's help
Hey, I resemble that remark 😀 and if that's...
June 22, 2011 at 5:38 am
Craig Farrell (6/21/2011)
opc.three (6/21/2011)
June 21, 2011 at 10:31 pm
Jeff Moden (6/21/2011)
opc.three (6/21/2011)
June 21, 2011 at 10:29 pm
Craig Farrell (6/21/2011)
opc.three (6/21/2011)
June 21, 2011 at 10:09 pm
Jeff Moden (6/21/2011)
opc.three (6/21/2011)
Jeff Moden (6/21/2011)
Craig Farrell (6/20/2011)
June 21, 2011 at 5:02 pm
sqldba_icon (6/21/2011)
GSquared (6/21/2011)
E.g.: If you...
June 21, 2011 at 4:22 pm
Viewing 15 posts - 5,926 through 5,940 (of 7,168 total)