Viewing 15 posts - 13,111 through 13,125 (of 19,560 total)
You're welcome.
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 27, 2010 at 3:24 pm
homebrew01 (9/28/2009)
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 27, 2010 at 3:24 pm
Using a local account for security can work. It complicates matters a bit when there is a need to deal with other computers on the network. It also...
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 27, 2010 at 3:10 pm
Or were you trying to download the SSIS Examples?
There is an X86 file (which is the link above) and there is an x64 file for download (which is the recommended...
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 27, 2010 at 3:03 pm
Is the file that you downloaded called "AdventureWorks2008R2_RTM.exe"?
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 27, 2010 at 3:00 pm
You could leave the space in the files. The space will be used later on. Empty space inside the data file is not fragmented within the file (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
July 27, 2010 at 2:54 pm
Do you have a plotter available?
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 27, 2010 at 2:51 pm
sushantkumar1984 (7/27/2010)
I think that did the trick...
but when I executed
Exec sp_change_users_login 'REPORT'
to see which all other users became orphan, there were 300 more...:(
so.. Is there a way to...
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 27, 2010 at 2:46 pm
gmby (7/27/2010)
Could you setup a SQL Agent Job to run the package, and then use sp_start_job ?jg
That's probably the best bet without xp_cmdshell.
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 27, 2010 at 2:44 pm
Jack Corbett (7/27/2010)
CirquedeSQLeil (7/27/2010)
Jack Corbett (7/27/2010)
CirquedeSQLeil (7/27/2010)
... Dicaprio doesn't do it for me ...
So may places to take that, I don't even know where to start and not sure...
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 27, 2010 at 2:37 pm
Try changing the default database to the dynamics database.
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 27, 2010 at 1:03 pm
I would be careful of removing even tables that have no rows. I have seen many of those used in queries throughout an application. If the table is...
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 27, 2010 at 12:59 pm
Is the package stored as a structured file or is it stored in SQL server?
http://msdn.microsoft.com/en-us/library/ms138023.aspx explains a few options for running a package.
One of those options is dtexec.exe. ...
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 27, 2010 at 12:30 pm
sushantkumar1984 (7/27/2010)
{Microsoft} {odbc sql server driver} the server principal 'abc' is not...
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 27, 2010 at 12:11 pm
majida2z3 (7/27/2010)
i need to create a table which can populate the output of any duplicate value. and then i have to generate a report
This statement seems broad to me. ...
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 27, 2010 at 12:09 pm
Viewing 15 posts - 13,111 through 13,125 (of 19,560 total)