Viewing 15 posts - 10,171 through 10,185 (of 26,489 total)
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...
August 10, 2012 at 10:31 am
Probably be easier if you saved the execution plans as .sqlpan files and uploaded those. The graphical plan would be much easier to read.
August 10, 2012 at 9:37 am
Eugene Elutin (8/10/2012)
August 10, 2012 at 9:36 am
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...
August 9, 2012 at 5:28 pm
santhosh411 (8/9/2012)
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...
August 9, 2012 at 4:13 pm
You can start by reading this article: http://www.sqlservercentral.com/articles/T-SQL/67898/.
August 9, 2012 at 4:12 pm
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.
August 9, 2012 at 4:08 pm
Ajdba (8/9/2012)
Only one column which is Year
This help?
DECLARE @Years TABLE (years VARCHAR(6));
INSERT INTO @Years(years)
VALUES ('2010'),('2011'),('2009'),('2005'),('2003');
SELECT TheYears = STUFF((SELECT ',' + years
...
August 9, 2012 at 4:06 pm
Lowell (8/9/2012)
I thought sysindexes is deprecated.and that made sys.sysindexes the replacement?
If you check here you'll see that there are actually 4 system views/DMV's that replace sysindexes.
August 9, 2012 at 3:57 pm
JeremyE (8/9/2012)
Lynn Pettis (8/9/2012)
SQLJocky (8/9/2012)
August 9, 2012 at 1:05 pm
SkyBox (8/9/2012)
Lynn Pettis (8/9/2012)
August 9, 2012 at 1:02 pm
pooyan_pdm (8/9/2012)
August 9, 2012 at 12:53 pm
dirtyshorellc (8/9/2012)
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...
August 9, 2012 at 12:45 pm
shahgols (8/9/2012)
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...
August 9, 2012 at 12:19 pm
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...
August 9, 2012 at 12:17 pm
Viewing 15 posts - 10,171 through 10,185 (of 26,489 total)