Viewing 15 posts - 31 through 45 (of 149 total)
Here's an implementation of the technique described in part 2 written in an ASP.net web project.
http://texastoo.com/post/Implementation-for-Introduction-to-Bitmasking-in-SQL-Server-part-2.aspx
June 2, 2009 at 10:29 am
GregoryAJackson (5/22/2009)
I agree.It's "cool", etc. but it doesnt seem practical.
GAJ
Sweet! Thanks bro
GregoryAJackson (5/22/2009)
I'm not a fan of this in the world of RDMS's
It's "cool", etc. but it doesnt seem...
May 25, 2009 at 8:41 am
Andrew Peterson (5/22/2009)
If you approach the bitmask column for the purpose of high frequency searching, really for "reporting" then...
May 25, 2009 at 8:36 am
mike brockington (5/22/2009)
In my dictionary, elegance requires something to be as simple as...
May 25, 2009 at 8:35 am
Great point, Leo. For over 64 items you'd have to revert back to the method in part one, or make multiple masks to handle the additional options.
Thanks much
May 21, 2009 at 7:18 am
greggoble2 (5/20/2009)
Looks like this would be great for when rollback scripts aren't provided during deployment time!
No kidding. And much easier to implement as well. How many times have I written...
May 20, 2009 at 3:05 pm
Very handy! Good job, here.
Thanks for sharing
Lee
May 20, 2009 at 12:47 pm
I would just migrate the data out of master and then remove it after your application is back online. No need to rebuild the master database - rebuildm is a...
May 16, 2009 at 8:26 am
I've seen this before and started changing out source/destination connection types to find which ones work better. That's not the best answer out here but what I have used when...
May 12, 2009 at 7:30 pm
Just a shot in the dark...try nvarchar()?
May 12, 2009 at 7:23 pm
I'd add some service packs as well while you figure this out 🙂
April 18, 2009 at 4:01 pm
Sounds like something very simple. Create a job to monitor the table via a TSQL query, and send the mail if conditions are (or aren't) met. What I would do...
April 18, 2009 at 3:59 pm
Another option is that there are several companies that have a "remote dba" services available to handle all of your tasks while you are hiring your new dba. I know...
April 18, 2009 at 3:54 pm
Sweet!
Now go into perfmon and open up the SQL Server: Databases performance object. Throw in Transactions/sec for tempdb, and then _total (for all databases of course), and divide up to...
April 7, 2009 at 2:00 pm
This is a good counter, but again, you need to look at others as well. Did you divide the number of disks by your value to get the true queue...
March 30, 2009 at 8:12 am
Viewing 15 posts - 31 through 45 (of 149 total)