Hear is nice artical about Why I Hate DISTINCT http://weblogs.sqlteam.com/markc/archive/2008/11/11/60752.aspx Thanks Jagblue
Good news: there's a SP3 Beta!! http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA&displaylang=en What's...
Hi All, 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...
Hi Louis asuming each buccket has atlest 20 coins Take 1 coin from #1 2 Coin from #2 3 Coin from #3 and so On and weight all this coin together and...
Hi, 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) then...
Hi, 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...
Hi Mohammed, Information Schma views is supported in SQL 2005 For SQL 2000 we need to query system tables depend on Kind of Information we need....
Hi, Change your WHERE Cluse Like this WHERE SourceID = ' + convert(VARCHAR(10),@SourceId) + ' AND (' + convert(VARCHAR(10),@Zoom) + '=-1 OR '+...
Hi All SELECT * SYS.COLUMNS WHERE COLUMN_ID NOT IN (SELECT COLUMN_ID FROM SYS.IDENTITY_COLUMNS) AND OBJECT_NAME(OBJECT_ID) = 'tblname' Will give you...
Hi Look at this Whitepaper http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm#_Toc79339942 Thanks
It’s Ok But don’t put it as your first column try to put Bit column last in composite indexes so you will have batter selectivity Thanks
Hi Try this Procedure if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[proc_genscript]') and OBJECTPROPERTY(id,...
Hi 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 INNER...
Hi, 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...
HI BY defination 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...
Hi All, 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...
Hi 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...
Hi 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.
