Hear is nice artical about
Why I Hate DISTINCT
Good news: there's a SP3 Beta!!
Is this a Bug in SQL 2005
I wants to keep select into/bulkcopy and trunc. log on chkpt. Option on
but as soon as I turn on trunc. log on...
Hi AllI have a unique situationWe have a table wilt around 4 million+ records and growing 100k + per monthAnd we are planning to add around 26 new...
asuming each buccket has atlest 20 coins
1 coin from #1
2 Coin from #2
3 Coin from #3
and so On
and weight all this coin together and...
what you can do create a dummy column of datatype CHAR(10) and UPDATE thet coulmn like this
SET newcol = CONVERE(VARCHAR(10),oldcol,101)
It looks like you are repeating last case statement in order by clues
That why you get an error.
If you remove last case statement you want get...
Information Schma views is supported in SQL 2005
For SQL 2000 we need to query system tables depend on Kind of Information we need....
Change your WHERE Cluse Like this
SourceID = ' + convert(VARCHAR(10),@SourceId) + ' AND
convert(VARCHAR(10),@Zoom) + '=-1 OR '+...
SELECT * SYS.COLUMNS
WHERE COLUMN_ID NOT IN (SELECT COLUMN_ID FROM SYS.IDENTITY_COLUMNS)
AND OBJECT_NAME(OBJECT_ID) = 'tblname'
Will give you...
Look at this Whitepaper
But donâ€™t put it as your first column try to put Bit column last in composite indexes so you will have batter selectivity
Try this Procedure
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[proc_genscript]')
Try your Query Like this
SELECT DISTINCT table1.B_CODE
FROM Table1 as table1
INNER JOIN Table2 as table2 ON table1.C_CODE = table2.C_CODE
Instead of using Import wizard create new SSIS package
In Import/Export wizard default batch size is 0 i.e. data want committed until everything...
If you want to see all the records of one input Table independent of whether there is a matching record in the other table or not....
more detail on NOLOCK as per BOL
Using locking hints in SQL Server Mobile is similar to that of SQL Server. However, for SQL Server Mobile, the...
Our current production SQL Server is SQL 2000 sp4
And soon we are planning to migrate to SQL 2005 sp2
We have a unique situation
We r using...
I have two tables History and Defination
and Definafoin has Pk on DefID
History has 25,000,000records and Defination has 50,000
I have a procedure...
Try this statment
DELETE FROM tblFinalArchive WITH (ROWLOCK, UPDLOCK)
WHERE (dTimeSent < CONVERT(DATETIME, '2002-12-31 00:00:00', 102))...
Separate names with a comma.