Viewing 15 posts - 1 through 15 (of 19 total)
Where are those analysis pages coming from? Is it a feature in SQL activity monitor? If so, please advice the proper steps to do what you show. ...
September 13, 2012 at 8:36 am
It is good to know we can do this. Thanks. Can this technqiue use in the reverse? The data source is SQL table and output...
October 21, 2011 at 10:12 am
Replaceing (local0 with the server name doesn't work either.
July 8, 2011 at 11:43 am
Did u get this resolved? I currently am having the same issue.
July 5, 2011 at 4:10 pm
No, the high selectivity fields (like primary key in a table) are in the joins and low slectivity field such as status is in the where clause.
January 21, 2011 at 11:02 am
Great series.. They bring back some forgotten concepts. Thanks
I do have a question on the 'Include' feature in nonclustered indexes. You touch on...
January 21, 2011 at 9:10 am
Lets say we can't use sp_addremotelogin, how do you do this in SQL 2008 using both SQL command and SQL management tool? I like to see both method.
October 1, 2009 at 3:44 pm
Yep, double \\ works. The files are saved in the right path with the correct name.
May 20, 2009 at 4:35 pm
Your command got the same error....... but guess what..... your new command again showed me something different... For the last argument, you remove the last '\' from the file...
May 20, 2009 at 4:11 pm
ok, I will try that. Can you tell me what wrong with the following command?
dtexec /F "C:\DTSPackage\MySolution.dtsx" /SET "\Package.Variables[EmployeeID].Value";162 /SET "\Package.Variables[OfficeCode].Value";"10" /SET "\Package.Variables[sFilePath].Value";"N:\exportfile\"
When I ran...
May 20, 2009 at 3:29 pm
thank for the reply. The thread that you pointed me to actually help me to solve it although it is not pretty. The thread mentioned about opening the...
May 20, 2009 at 1:09 pm
Thanks for the reply. Actually I did try that before I posted my question, it returned an syntax error. Your command is almost exactly like mine except that...
May 19, 2009 at 4:31 pm
I need to clarify my 'it is working' statement in my reply. If I directly typed in the custom row delimiter, it would work. But if I define...
May 15, 2009 at 3:04 pm
The bypass thng doesn't work. You mention about building a variable for the sql statement, do you mean doing somethig like this?
Declare @sqlcmd varchar (max)
select @sqlcmd ='select xxxxxxxx'
May 13, 2009 at 4:39 pm
thank for the reply.
Is there some special attention needed for setting up parameter if the Select statement involves an Union. For example,
select LastName, First name from tblemployer...
May 13, 2009 at 3:16 pm