Good one. Always used '%' as wild card.

Does any one know of a tool which actually converts T-SQL procedures/Triggers/Functions to PL/SQL ?

I had got the project where they need to convert code to pl/sql format. Only...

I think question should be rephrased as what's the size of new DB on disk and also sql server version.

It is 2 Mb mdf + 1 MB ldf = 3...

Jason Shadonix (1/19/2010)

---

Just out of curiosity, has anyone ever run up against the 250 index limit in SQL 2005. I can't imagine ever needing that many in our environment....

Here is an another link for comparing all versions.

http://www.sql-server-helper.com/sql-server-2005/maximum-capacity-specifications.aspx

For us it actually/nearly crashed a server. Original DB size was 34.45 GB but snapshot grew more than 78 GB where the Disk size allocated was 80 GB.

From there...

Good question. I thought its an operator. But, after some googling found though it could be called an operator but would be considered in Predicate.

Predicate (Transact-SQL)

Is an...

Execute below SQL to actually see more duplicate indexes on your database. I would remove the duplicate indexes, if any, but as Gila said yours doesnot seems...

It should work ! What's the deal ?

Anyway, My wishes to all for Happy New Year - 2010.

May you all get all points next year in...

You cannot drop " sys " user from any database since it owns sys schema. Though this user " sys " is not assigned any role by default.

execute this...

Doesn't 8,1,16,16,25,27,2,9,18,20,8,4,1,25 stands numerical order for HAPPY BIRTHDAY in alphabets.

In code is selecting top 26.

(...

sysrules in option. Good way to Trick.

Never seen object like this.

Interesting question.

Never knew until now that there is something like MULTIFLATFILE data connection in SSIS.

Will try next time in multiple data uploads.

Thanks for a good question.