Viewing 15 posts - 256 through 270 (of 424 total)
Why would an application use your system DSN?
Maybe there is an app config or app registry setting.
April 7, 2015 at 8:24 am
A deadlock is pretty simple to understand. If you and I want to rent two movies, Matrix1 and Matrix2, and each of us grabs one of the movies, we...
March 11, 2015 at 10:01 am
Often a multi-threaded app may cause very frequent deadlock conditions. In this case the app needs rewritten. Deadlocks are a normal and expected condition and are not errors....
March 10, 2015 at 2:34 pm
The devil is always in the details. Without knowing specifics we can only give ideas here. For example, what is wrong with clustering on something non-sequential if you...
February 27, 2015 at 12:05 pm
There is always more than one way to skin a cat. My preference is to optimize simplicity and maintainability. Each part can be tested individually and there are...
February 27, 2015 at 7:35 am
In SSMS, open three sheets and run sheet 0. Then run sheet 1 and 2 within 10 seconds of each other.
Remember to do rollbacks in sheets 1 and 2...
February 25, 2015 at 10:45 am
My experience with huge queries is that they run linearly but SSMS gets result batches in a non-linear fasion. For example, it may show 10 result rows at a...
February 17, 2015 at 11:44 am
SQL!$@w$0ME (2/12/2015)
Hi guys,I need to generate data models of all databases for an instance. How can I accomplish this?
If anyone has done this before please share your thoughts.
Thanks!
Manual labor...
February 12, 2015 at 9:47 am
The only place I've used Base36 is to jam a lot of numbers into a short barcode. Just think how long a binary number is compared to a hex...
February 2, 2015 at 4:15 pm
K2mission (2/2/2015)
February 2, 2015 at 12:07 pm
Interesting problem. I see you want to consume inventory in expiration date order.
Personally I would do this procedurally in a loop in a stored procedure, filling a local table...
January 29, 2015 at 11:17 am
Take a look at the sample database you can download. It is AdventureWorks2008 and comes with a BillOfMaterials table and Production.Product table.
January 19, 2015 at 11:28 am
The Stephen Covey 7 Habits might be a simple answer but I think what is really going on is this:
The company is a system.
The IT department is a sub-system.
A sub-system...
January 16, 2015 at 11:11 am
Thank you all for the helpful pointers. I'm shocked! It turns out they are running Windows Server 2003 32 bit and no one ever configured AWE, PAE, Locked...
January 12, 2015 at 10:29 am
Viewing 15 posts - 256 through 270 (of 424 total)