Viewing 15 posts - 226 through 240 (of 583 total)
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.
November 4, 2013 at 1:35 pm
mbn 46383 (10/29/2013)
Thanks for the input, it appears that a simple UPDATE STATISTICS did the trick.
Statistics update invalidates the query plans for all tables whose stats were updated. I am...
October 29, 2013 at 8:21 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...
October 28, 2013 at 10:28 am
Luis Cazares (10/16/2013)
Cost isn't a real performance indicator. It's just an estimated value used by the query optimizer to choose an execution plan.
I am not overly concerned with performance in...
October 16, 2013 at 12:38 pm
Bhuvnesh (10/16/2013)
With such a small amount of data you can see the difference .. test it with millions or even thousands..
amount of data is irrelevent. with 1 million...
October 16, 2013 at 11:19 am
you can users either SSMS or t-sql to view the logs.
October 11, 2013 at 9:27 am
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...
October 3, 2013 at 1:10 pm
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...
October 2, 2013 at 3:34 pm
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...
September 25, 2013 at 8:38 am
once the proc is in production would you not want the results?
September 20, 2013 at 2:21 pm
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...
September 17, 2013 at 2:54 pm
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...
September 16, 2013 at 1:05 pm
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...
September 13, 2013 at 10:55 am
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...
September 10, 2013 at 3:31 pm
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...
September 10, 2013 at 2:22 pm
Viewing 15 posts - 226 through 240 (of 583 total)