tag:blogger.com,1999:blog-2307145203574942123.comments2014-05-12T10:34:43.351-07:00SQL ServerAnil Yadavhttp://www.blogger.com/profile/09905003317091006921noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-2307145203574942123.post-45747290168023279072014-05-12T10:34:43.351-07:002014-05-12T10:34:43.351-07:00taken Verbatum from http://www.mssqltips.com/sqlse...taken Verbatum from http://www.mssqltips.com/sqlservertip/1218/sql-server-bitwise-operators-store-multiple-values-in-one-column/<br />Postback links would be appreciated.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-44015685410422511162014-05-08T23:11:40.480-07:002014-05-08T23:11:40.480-07:00Great work dude!!
I have a temp table having data...Great work dude!!<br /><br />I have a temp table having data in millions and then have to iterate it. @ROWCOUNT iteration method added significant amount in terms of performance.<br />Tanks you.Anonymoushttps://www.blogger.com/profile/03431384726884910355noreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-85514816900446872792014-05-08T23:06:28.847-07:002014-05-08T23:06:28.847-07:00Great work dude!!
I have a temp table having data...Great work dude!!<br /><br />I have a temp table having data in millions and then have to iterate it. @ROWCOUNT iteration method added significant amount in terms of performance.<br />Tanks you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-70039779589694781422012-03-26T08:53:28.729-07:002012-03-26T08:53:28.729-07:00Great, Thanks!Great, Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-59348135737116302922011-12-18T22:42:38.722-08:002011-12-18T22:42:38.722-08:00I tried with this way.But data seems not being tra...I tried with this way.But data seems not being transferred to the new file group.Can you please help me with this?Hiranhttps://www.blogger.com/profile/15379673900372264743noreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-54415521726194659192011-08-16T05:56:52.995-07:002011-08-16T05:56:52.995-07:00Hi!
although it's a somewhat old post, I thin...Hi!<br /><br />although it's a somewhat old post, I think it's very nice and handy piece of code.<br />Anyway, you might want to check in an little mistake you made in the where-clause within the else-part at the very end:<br /><br />[...]<br />where tds.database_ID not in (Select Distinct DBID from DBGrowthRate<br />where DBName = tds.database_ID)<br />Group by tds.database_ID, tds.DBName)<br />[...]<br /><br />Here you're checking DBName against database_id which looks not sound to me...<br /><br />Cheers, <br />DaveAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-83224871649782843562011-07-26T00:15:42.066-07:002011-07-26T00:15:42.066-07:00I think now we should dbcc indexdefrag because it ...I think now we should dbcc indexdefrag because it is an online operation and users can continue working.ps3 wireless controllerhttp://ps3wirelesscontroller.orgnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-14910618208873765382010-08-05T03:12:22.154-07:002010-08-05T03:12:22.154-07:00Too good.... very useful..
ThanksToo good.... very useful..<br /><br />ThanksPankajhttps://www.blogger.com/profile/15290678290341697784noreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-49688791131620807742009-08-19T11:09:05.251-07:002009-08-19T11:09:05.251-07:00--In SQL Server 2005
EXEC xp_readerrorlog returns ...--In SQL Server 2005<br />EXEC xp_readerrorlog returns the columns such as:<br /><br />LogDate ProcessInfo Text<br /><br />--In SQL Server 2000<br />EXEC xp_readerrorlog returns the columns such as<br /><br />ERRORLOG ContinuationRow <br /><br />So the users must be more careful when they try to collate the results to a table or to any other data source for the change of columns.<br /><br />Parameters 6 and 7 are between dates!!! and only for SQL2005 and laterAnil Yadavhttps://www.blogger.com/profile/09905003317091006921noreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-35027511828926282362009-08-19T10:12:30.070-07:002009-08-19T10:12:30.070-07:00This is great. Thank you. I found this while resea...This is great. Thank you. I found this while researching how to report on individual database availability daily for 72 servers. This provides exactly what I will need for our 2005 servers, and it works on our 2008 test server. It doesn't work for 2000 servers. Is there a way short of reading the error log into a table, then searching for 'starting' in SQL Server 2000?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-63541045198164559522009-07-06T01:54:01.477-07:002009-07-06T01:54:01.477-07:00what sql server version , you are using ?what sql server version , you are using ?goHostinghttps://www.blogger.com/profile/17050065101849615321noreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-74671408473028150912009-04-03T11:22:00.000-07:002009-04-03T11:22:00.000-07:00Anil, how have things been going? Have you found ...Anil, how have things been going? Have you found a new job yet?Jim Cveykusnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-41117357140427429552009-02-27T13:09:00.000-08:002009-02-27T13:09:00.000-08:00If the "Limit" value is updated, the restriction i...If the "Limit" value is updated, the restriction is not enforced.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-90640157860627118262009-02-01T23:10:00.000-08:002009-02-01T23:10:00.000-08:00Time spent with you and others who are part of RLI...Time spent with you and others who are part of RLI is one of best phase of my life. We at ALS always tried to give our best shot. You are a good technical guy and very good human being. Take RLI to new heights of success. Keep in touch...Anil Yadavhttps://www.blogger.com/profile/09905003317091006921noreply@blogger.comtag:blogger.com,1999:blog-2307145203574942123.post-83135133598824040582008-11-13T21:10:00.000-08:002008-11-13T21:10:00.000-08:00Nice job Good Going Dear!!!Visit My Sitewww.discob...Nice job Good Going Dear!!!<BR/><BR/><BR/>Visit My Site<BR/><BR/>www.discobhangra.com<BR/><BR/><BR/>www.technewstime.comJimmyhttps://www.blogger.com/profile/08557198871665244486noreply@blogger.com