Jeff Moden (4/1/2008)

---

Matt Miller (4/1/2008)

---

Every time I hear of a "door" like this being opened, despite all of the assurances that it's a "one-way door", there's always some smarty finding...

Marios Philippopoulos (4/1/2008)

---

It's not about DBAs allowing devs direct access to production. It has nothing to do with that.

It's...

Luke L (4/1/2008)

---

Thanks, That was somewhat the route I was beginning to proceed down, but I wasn't sure exactly how to break up the table to create something that resembled...

Have you tried the new "reports" feature? Right-click on the database, pick Reports, Standard reports, "Disk usage by table". And voila - rowcounts (and much more) by table....

Hey...

I have no opinion on the matter at hand. I just think I need a nap after reading this entire thread....:)

Totally agree... I demand a recount:)

Especially if you've been listening to the new...

srienstr (4/1/2008)

---

Jeff Moden (3/31/2008)

---

On the "Persists" disadvantage, I kinda of agree if the sproc is big and the Temp table is used only at the beginning. I just want...

Antares686 (4/1/2008)

---

I want the half-geek/half-nerd with the C#/SQL...

Will DOugherty (4/1/2008)

---

How can they release this only for Xbox? They've neglected the PC gamers again! 😀

BTW: From the title, I was hoping for MS SQL vs. Oracle. ...

And just to prove that:

Here's the test data:

drop table matt1

create table...

As far as "building" the list you'd want for the "Acronyms to keep" list - use any one of the solutions identified here:

http://www.sqlservercentral.com/articles/Test+Data/61572/%5B/url%5D

Since I assume you want to run this...

Spell-checking is not available i think. It involves something interactive on a .NET control (the CLR we're talking here is not interactive and not user-control-based.)

This would be the CLR user-defined function you'd need:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.Text.RegularExpressions

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction(IsDeterministic:=True, IsPrecise:=True)> _

Public Shared Function...

Your WHERE clause is prompting the optimizer to turn this into an INNER JOIN, and not an outer join.

Meaning - by not allowing for c1.sequence to be null, it CAN'T...

Ahmad Osama (3/31/2008)

---

Hi,

I absolutely agree with both of you..but this is a clients request and the reason behind this is...

My Client is well known Computer hardware sales company...and they...