Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 3,221 total)

  • RE: Are the posted questions getting worse?

    Roy Ernest (12/23/2010)

    Happy Holidays to everyone....!!! I wont log on to SSC or anything. So, Have fun everyone... See you all after Christmas.

    And a happy holiday to you and yours...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 23, 2010 at 1:47 pm

    #1266064

  • RE: Are the posted questions getting worse?

    WayneS (12/22/2010)

    I finally got around to creating a connect item dealing with SQL Server not honoring default data/log file locations for new databases until the service is restarted here.

    I encourage...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 22, 2010 at 10:12 pm

    #1265769

  • RE: Subtle Line Feed / Carriage Return issue

    After being told that I had selected the wrong answer, I copied the code to SSMS for SQL 2005, and to SSMS SQL 2008 ....

    In BOTH 2005 and 2008...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 22, 2010 at 9:55 pm

    #1265768

  • RE: count no of months n days

    Examine the DATFDIFF and or DATEDIFF functions

    You answer seems to be incorrect 149 days ... even if each month between 08/25/2010 and some future date contained 31 days it...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 21, 2010 at 4:00 pm

    #1265319

  • RE: How to delete duplicate rows form SQL 2008 database

    ns_18 (12/21/2010)

    I want to implement the below scenario.

    If ther is any duplicate data then my SQL should run and find the duplicate rows and then delete them automatically.

    Do you...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 21, 2010 at 3:29 pm

    #1265311

  • RE: How to delete duplicate rows form SQL 2008 database

    ns_18 (12/21/2010)

    I want to implement the below scenario.

    If ther is any duplicate data then my SQL should run and find the duplicate rows and then delete them automatically.

    Do you...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 21, 2010 at 2:31 pm

    #1265285

  • RE: Professional Ethics

    Anthony Johnson-756248 (12/21/2010)

    Please provide data access controls that should be a standard to the database administration and data control areas of the community.

    Your question is rather vague, however you may...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 21, 2010 at 9:28 am

    #1265151

  • RE: Filtering by column

    This will allow you to view specific columns by name, or by data type along with their associated table name.

    SELECT so.Name AS 'Table',sc.Name AS 'Column'

    FROM sys.sysobjects so...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 20, 2010 at 5:11 pm

    #1264849

  • RE: The Twelve Days of SQL

    I realize this is a "global" community and many folks don't celebrate Christmas but here's to the folks who keep SQL Server Central alive and kicking including employees, lurkers, casual...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 18, 2010 at 7:33 pm

    #1264416

  • RE: SQL2005 SP4 is here

    Thanks for the heads up ... nice quite Saturday .... downloading was quick ... Again thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 18, 2010 at 7:33 am

    #1264366

  • RE: Translate script from 2005 to 2000

    I do not envy your chore, but would suggest using a search of TECHNET

    to find the information you require.

    http://social.technet.microsoft.com/Search/en-US?query=sql%20server%202005%20compatability%20views&ac=3

    The link above will return some 8,780 references, amongst which I believe...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 17, 2010 at 8:14 am

    #1264087

  • RE: T-sql

    Trivial question

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 16, 2010 at 9:03 pm

    #1263863

  • RE: Are the posted questions getting worse?

    WayneS (12/16/2010)

    bitbucket-25253 (12/16/2010)

    WayneS (12/15/2010)

    My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?

    Wayne I believe it was a good question, and...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 16, 2010 at 1:57 pm

    #1263715

  • RE: Shrink TempDB

    Try reading the following articles / blog posts to determine additional methods or items to check to determine why tempdb is not shrinking.

    http://www.sqlservercentral.com/blogs/adventuresinsql/archive/2009/12/17/how-to-shrink-tempdb-in-sql-2005.aspx

    and

    http://www.sqlservercentral.com/articles/tempdb/65919/

    http://www.sqlservercentral.com/articles/Editorial/71888/

    http://www.sqlservercentral.com/blogs/steve_jones/archive/2009/11/30/what-s-using-space-in-tempdb.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 16, 2010 at 1:10 pm

    #1263675

  • RE: Are the posted questions getting worse?

    WayneS (12/15/2010)

    My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?

    Wayne I believe it was a good question, and I for...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    December 16, 2010 at 11:21 am

    #1263619

Viewing 15 posts - 1,561 through 1,575 (of 3,221 total)