Have one database. The division is an entity in the database. You can then have a normal environment that an educated person would design. Can you...
Turn the getIpnumber into a table function. Join to the table function instead of calling it each time in the WHERE clause. This will allow you to...
<img src='/community/emoticons/emotion-1.gif' alt=':)' /> The only places are on a development environment, or one where downtime isn't...
Oh no. Why would we want to lock this? It's just getting interesting. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br...
Or stored professional. I keep a few of them locked in my trunk. Shhhhh. MeanOldDBA derrickleggett@hotmail.com When life gives you a lemon, fire...
Congrats Madhi. All you mega-posters amaze me. lol I am always stunned when I see people like Satya and Tara Kizer with 18 million posts...
After you create the index, let us know the results. If you could post a specific example with sample table structure and queries, we could help you...
There are a ton of great books out there. I've spent almost a thousand dollars buying books and e-books for my group over the last few months....
You can use the dir command with the /AA and /B options to only get files marked as archive. Using /B gives you just the filenames, so you don't...
What cache settings did you modify? What did you modify them to? What does your physical read and write queue lengths look like on each of these...
Don't ever use RAID 0 for tempdb. If you lose one of those drive, you just crashed your server. Go with what Joe configured for you. It's a great...
dosberg is right on this. <img src='/community/emoticons/emotion-1.gif' alt=':)' /> We had a few hotfixes from MS that addressed this issue with...
I would use merrill's solution. Select n records from Server1.tablea into a temp table. Join that the Server2.tablea and delete. This accomplishes...
If you have both int and numeric data coming out of this, you aren't going to get a final resultset that's part int and part numeric. This is...
alzdba, I think you are a little confused. The /PAE switch DOES enable AWE. It's a switch in the boot.ini file to allow addressing of of upper...
If you have awe enabled and the /3GB switch enabled, your OS is still only going to free up totalmemory-1GB for your applications to use. On some...
If they generate more revenue, more power to you. They are kind of odd, but they don't bother me. I'm an odd person though, so you can't really use...
<pre id="code"><font face="courier" size="2" id="code"><br />DECLARE @table TABLE (Col1 CHAR(1), Col2 CHAR(1), Col3 INT)<br /><br />INSERT...
You need to post the exact RESTORE statements he used and the exact error. You should be able to restore using the WITH MOVE option to the new...
I also prefer to track for a week at a little larger interval. When you track the physical disk counters, pay close attention to the IO and queue...
Separate names with a comma.
