Eugene Elutin (8/10/2012)

---

...

I like the idea of having a sid (a surrogate id) on my tables, even if I do have a natural key that can serve as a primary...

Probably be easier if you saved the execution plans as .sqlpan files and uploaded those. The graphical plan would be much easier to read.

Eugene Elutin (8/10/2012)

---

Some people will tell you that you should always use natural keys (JC the master of them :-)) and others will tell you that you should always use...

I don't think you will find a tool that will compare the schemas of different RDBMSs. The differences in datatypes alone could make this difficult. For instance, SQL...

santhosh411 (8/9/2012)

---

Hi,

simple scripts Purging the old records in table.

I have more than 1Lakh records, can any one tell me simple way to purge this old records.

i am using below scripts

delete...

You can start by reading this article: http://www.sqlservercentral.com/articles/T-SQL/67898/.

All Hail The Thread

I apologize for getting really snarky on that post I just made. Please forgive me, but I just had to do it.

This help?

DECLARE @Years TABLE (years VARCHAR(6));

INSERT INTO @Years(years)

VALUES ('2010'),('2011'),('2009'),('2005'),('2003');

SELECT TheYears = STUFF((SELECT ',' + years

...

If you check here you'll see that there are actually 4 system views/DMV's that replace sysindexes.

JeremyE (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

SQLJocky (8/9/2012)

---

I'm trying to figure out why this log file won't shrink down past a certain size. I'm doing it on a brand new database I'm...

SkyBox (8/9/2012)

---

Lynn Pettis (8/9/2012)

---

Is this table fairly active regarding Update/Inserts/Deletes? It is possible that the statistics were automatically updated by SQL Server using a sample of the data, whereas...

pooyan_pdm (8/9/2012)

---

you van use rowmodctr column in sys.sysindexes to check the number of rows inserted,updated or deleted in the index since the last time stats were updated on that index.from...

dirtyshorellc (8/9/2012)

---

Hello,

I am new to SQL and have been asked to perform a query of our Dispatch database. Although I am able to pull most of the information I need...

shahgols (8/9/2012)

---

Hi all,

I'm new to SSIS, so I'm sorry if the question is very basic. I am having a hard time finding the error generated when I execute my...

Is this table fairly active regarding Update/Inserts/Deletes? It is possible that the statistics were automatically updated by SQL Server using a sample of the data, whereas the index rebuild...