Viewing 15 posts - 1 through 15 (of 25 total)
Thanks for this, I was just looking for some way of reversing the varbinary to SID. Trying to see just how much work I need to do as part of...
August 1, 2011 at 5:49 am
I had an instance once where we were being pushed to deploy a small website internally with the SA password in clear text in the page and hence clearly visible...
May 3, 2011 at 9:38 pm
We set the same exclusions, however it looked like the AV was actually scanning the network traffic that was comming into the SQL Server exe. Rather frustrating.
June 11, 2010 at 11:14 am
Pual
Those are some useful DMV's, cheers for the pointers.
In response to some of your queries;
Querying dm_exec_requests the current percent complete is sat at 0 and showing an estimated completion time...
May 21, 2010 at 6:11 am
Thanks for the insight.
We suspected as much with the threads being hung, we have tried stopping and starting DTC but alas it has not worked.
It is looking more and more...
May 20, 2010 at 7:26 am
Cheers for that, I know I can't kill a rollback. Rather trying to force the damn thing to get a higher priority so that it actually actions. We are indeed...
May 20, 2010 at 4:59 am
That is what we were thinking, the fact that there is no compatability mode for 7 on 2008.
Cheers for the comment on BULK INSERT, nice to know that others are...
May 10, 2010 at 5:14 am
Cheers for that, I had not thought about using the script task to do that. I'll have to explore things a bit more.
🙂
March 10, 2010 at 4:51 am
How big are the tables that you are looking to partition, also what are the typical quieries that are being run against them? To be reaching the limit of BIGINT...
February 10, 2010 at 7:53 am
Cheers for the ideas.
In the end I chose to break things down and did things in the following manner
1. Create partition function & scheme
2. Rename data table with sp_rename
3. Create...
February 10, 2010 at 7:40 am
My personal preference in this situation would be to break things up with multiple files/filegroups and only use hardware RAID.
You can find a bit of information at the following link...
February 9, 2010 at 9:17 am
Don't suppose you could send me the RDL so that I could have a quick play with it.
I have done a load of stuff with default/refreshing parameters recently, just finding...
February 8, 2010 at 7:58 am
In the end I convinced the powers that be on a different drive configuration, basically haggled the hardware vendor down enough to get the number of drives for a good...
September 21, 2009 at 2:02 pm
Correct me if I am wrong but does AX 4.0 use filtered views to pull data back when used with SSRS.
In AX 2009 you retreive data from the AOT Query...
July 23, 2009 at 4:04 am
I found out that the chain was being broken by out Sys-Admins taking system snapshots with BESR by symatec even though it was not activly backing up the databases with...
December 29, 2008 at 3:58 pm
Viewing 15 posts - 1 through 15 (of 25 total)