[font="Verdana"]Any workaround? :doze: Please[/font]

SQLRNNR (7/23/2012)

---

Jeff Moden (7/23/2012)

---

SQLRNNR (7/23/2012)

---

I would just call the stored procedure from within SSIS if you must convert it to SSIS. I'm not sold that SSIS is the right...

yes, the performance impact is also a key driver!

But we have some other business requirement, as...

[font="Verdana"]Simply ~Hats off~! Great![/font]:smooooth:

okbangas (6/4/2012)

---

use tempdb;

go

create sequence MyIDs as int

start with 1

increment by 1

no cycle;

go

create table MyTable (

id int default next value for MyIDs,

value varchar(50)

);

create table MySecondTable (

id int default next value for...

[font="Verdana"]Thanks for the brief and meaningful article!

Its long since MS-SQL Server has defended IDENTITY as a close alternative of Sequences objects, available in Oracle RDBMS.

Now what was the actual requirement...

[font="Verdana"]So.... Never, Ever Use clustered indexes ... while working with oracle 😀

just kidding !!! :hehe:.

[/font]

[font="Verdana"]

We dump data in history tables via triggers etc logic in old tracking...

[font="Verdana"]Great...

Jeff Moden (5/12/2012)

---

Good article, Steve. I believe that you've hit the nail on the head. So many managers think that Hours worked = Hours wisely spent = Good...

PaulB-TheOneAndOnly (4/24/2012)

---

Abrar Ahmad_ (4/24/2012)

---

[font="Verdana"]Do we can list down the basic difference in data types of different DBMS like Oracle, SQL, MySQL and DB2, while keeping in view the migration cost...

ColdCoffee (3/27/2012)

---

How about this?

SELECT T1.ID

,T1.DUE_DTE

,max_ind...

[font="Verdana"]Great Pick![/font]

[font="Verdana"]Good work,

But if we can summarize/list the three attack vectors in bulleted form here?

Thank you[/font]

Abrar Ahmad_ (10/4/2011)

---

[font="Verdana"]SSMS-Text Editor Font (Readability) affected automatically, and switched to old fashioned layout as that of SQL 2K Query Analyzer or even of Enterprise Manager of SQL 2K! (very...