Creating Queues

The SQL Server Features that Time Forgot

Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well, amongst the marketing people anyway. What happens to all the exciting TLAs that are bandied about when a new version launches? It's mixed, it seems. Adam Machanic's classic post, The SQL Hall of Shame, has inspired Rob Sheldon to look back at some of the features that, though worthy, have may have failed to hit the mainstream.

Service Broker Message Types

Queues in Databases

The idea of using a queue in a database is one that some people try to avoid, preferring to use a messaging service. However, Steve Jones notes that this isn't always necessary.

Get Your Service Broker Messages in Order. Always.

Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.

How can I pick mid month?

Hi Expert,Please help, I'm stuck with this.If the current date is 04/15/05, I want to set my date to 4/30/05 If the current date is 05/31/05, I want to set my date to 6/15/05. Please advice. Thanks a million.Minh

RE: Fragmentation with Clustered Primary Key?

The argument was that in the case above, there would be no fragementation and therefore no reason to ever reindex the table.  Also, no reason to set a fillfactor.  Does that hold true?

RE: SQL Server Enterprise Manager new feature

brrrr. Do you really want that? In big tables you are not doing a very smart thing... I thing you should not do that. Just right click and then open tables and return all row's.Are you updating tables that way? Or where do you want to use it for? If it is just 'select * […]

RE: Is a "delete" really 100% gone?

"There must be no residual data from the former object". IMHO, the only place a residue can be found, is on the harddrive. This means that 'a copy of a mdf' file is not the place to search for residue's. You need a stolen hard drive, sectorscanning and some deeplevel i/o knowledge on MSS. Not […]

RE: Pet Peeves

Here is Seattle they let us pump our own gas. Isn't big bro nice? I swear, there's all this crazy stuff going on and people make rules about pumping gas. My pet peeve? The US intertainment history as a whole...it's one big rip-off scam. For example, musicians are lucky get 1% of the profit on […]