Reputation
207
Top tag
Next privilege 250 Rep.
View close votes
Badges
3 11
Newest
 Critic
Impact
~3k people reached

Dec
18
awarded  Critic
Dec
17
comment Changes to data ordering between SQL Server 2000 and 2012
It is highly likely that the changes in the query optimizer from 2000 to 2012 has chosen a more optimal path to satisfy the query in the stored proc. The more optimal path likely involves using an index that is resulting in the rows being returned in a different order. The solution is and only ever will be to add an ORDER BY clause to the query.
Dec
17
comment SQL Server Express 2012 R2 shuts down when trying to connect via SQL authentication
Maybe show the log file contents in your question. It will almost certainly have the reason for the shutdown.
Dec
17
comment Dynamics AX Database Autogrowth Recommendations
You may run into timeouts in Dynamics if the log cannot be grown quickly enough. Depending on the type of disk subsystem your log is on, you may be able to get away with a much larger autogrowth setting. Test it on a non-production system.
Dec
17
answered How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it
Dec
17
answered What carries out SQL Server Mirroring?
Nov
13
awarded  Yearling
Nov
13
comment unable to load dll 'olepro32.dll' the specified module could not be found
Welcome to DLL hell. You might be experiencing a problem where the specific version of olepro32.dll is not loaded onto your system. Is this some software that you wrote? Or do you know the developers? You may need to ensure their setup package contains the correct olepro32.dll the application was compiled with.
Nov
6
accepted How can I reliably determine the hardware version of a VMWare Guest from inside the guest?
Oct
30
comment How can I reliably determine the hardware version of a VMWare Guest from inside the guest?
@EGr - thanks for offering a bounty on this!
Oct
30
comment How can I reliably determine the hardware version of a VMWare Guest from inside the guest?
I was attempting to audit the configuration of hundreds of VMs - looking for anomalies that might explain performance issues on some of them. I have access to run executables in the VMs, and was hoping to exploit that ability as a way to understand exactly how the host is configured.
Oct
16
revised Enabling IPv6 for docker breaks hosts IPv6 connectivity resulting in neither having IPv6 connection
fixed spelling of brakes
Oct
16
suggested approved edit on Enabling IPv6 for docker breaks hosts IPv6 connectivity resulting in neither having IPv6 connection
Oct
16
comment Error configuring witness server for failover in SQL Server
Are you using the GUI or T-SQL commands to setup mirroring?
Sep
18
awarded  Popular Question
Sep
5
awarded  Constituent
Aug
31
awarded  Caucus
Jun
12
asked How can I reliably determine the hardware version of a VMWare Guest from inside the guest?
Mar
20
awarded  Scholar
Mar
20
accepted How can I determine if the Windows Server I'm looking at is using a mutliprocessor capable HAL?