This is the wait when you are viewing live extended events data. I'm sure it would be safe to exclude it from the list.

Statistics update invalidates the query plans for all tables whose stats were updated. I am...

Do you get the same plan when run through the application?

Do you always get the same plan when using different parameters?

How different are the estimated to actual rows...

I am not overly concerned with performance in...

amount of data is irrelevent. with 1 million...

you can users either SSMS or t-sql to view the logs.

http://technet.microsoft.com/en-us/library/cc280728.aspx

it may be permissions. Does the agent service have permission to the sharepoint folder? if permissions are correct you could try the actual path instead of mapped drive. something like:

XCopy...

If you wanted to have the 2012 SSMS open with just ssms.exe you can reorganize you "path" environment variable. move "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio" the the beginning of the...

I dont think there is an official microsoft 32bit driver for linux, only 64bit.

There are non-free options like easysoft. For a free option there is freeTDS[/url]. I have palyed...

once the proc is in production would you not want the results?

check out the workaround in this connect item. http://connect.microsoft.com/SQLServer/feedback/details/228950 It's pretty old so I don't know if it is applicable anymore.

you might also want to look at the permission of...

there area couple of other ways to accomplish this but I dont think either will be more efficient. you can use a case statement or dynamic sql.

here is an...

check if the trace is still exists.

SELECT id,status,path

FROM sys.traces

If it exists and is running(status 1) you wont be able to delete the file. Even if...

i wasn't paying attention, I had the filename string incorrect.

try this:

$filename = $instanceName+"_Configuration_"+$Date+".csv"

I was able to get it to run successfully with a modified script on sql server 2008...

try changing

$filename = "$($instanceName)_Configuration_$($Date).csv"

to

$filename = "$instanceName_Configuration_$Date.csv"

I wasn't able to get it to run in my test but making after making this change i no longer got the bad syntax...