Forum Replies Created

Viewing 15 posts - 28,891 through 28,905 (of 49,552 total)

  • RE: Reuse of Identity column values

    Caruncles (12/14/2010)

    I'm not familiar with setting up a trace file. Will it reveal records (or gaps) which have been deleted via SSMS (or Enterprise Mgr)?

    Depending what you trace, it...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 7:35 am

    #1262217

  • RE: How do I know when to use temp tables/table variables?

    Jeff Moden (12/14/2010)

    SQLNW (12/13/2010)

    hi everyone ,request your help urgently.

    Conversion failed when converting the varchar value '12.80' to data type int. I checked all the datatypes in my procedure

    thanks for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 7:32 am

    #1262213

  • RE: Are the posted questions getting worse?

    Thunderstorms here, but no snow storms. (I'd worry if there were)

    Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.

    It almost resulted in coffee...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 7:29 am

    #1262208

  • RE: Database Backup

    Deepthy (12/14/2010)

    There isn't any sql agent job setup in sql server agent for backups.

    If there's no job, then nothing is going to be running on any schedule. The job is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 7:26 am

    #1262204

  • RE: Reuse of Identity column values

    See edit to previous post for comment on that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 7:10 am

    #1262180

  • RE: Reuse of Identity column values

    Identity values are not reused. Not after a delete, not after a rollback of an insert.

    Not sure about that query (and haven't tested). Easiest way would be to take a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 7:06 am

    #1262175

  • RE: Database Backup

    Is SQL Agent runnning?

    Are the jobs failing, or just not running?

    Are the jobs enabled?

    Are the schedules enabled?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 7:02 am

    #1262170

  • RE: unique clustered index on 2 columns

    Abhijeet Chavan (12/14/2010)

    beginners SQL book will really help to understand the concept of Indexes.

    Or maybe the introductory series I wrote on indexes?

    http://www.sqlservercentral.com/articles/Indexing/68439/

    When we say clustered index can also have...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 5:17 am

    #1262121

  • RE: Urgent Help - Consistency Errors after running CHECKDB

    Also asked: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=154178

    I will be directing replies to the post at SQLTeam.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 5:14 am

    #1262120

  • RE: Reducing data file size prior to a database move

    How are you moving them? Detach/attach? Backup/Restore?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 3:42 am

    #1262097

  • RE: using "IF" in Query

    You can't use IF within a select query. Open up the SQL Books Online (press F1 while in Query Analyser) and look up CASE

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 1:00 am

    #1262061

  • RE: using Group with Query

    As the error says, you have the WorkID column in the select clause but it's not present in the group by. You need to either remove it from the select...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 14, 2010 at 1:00 am

    #1262060

  • RE: Round to next 1000 or 100 without Ceiling function

    Seriously?

    Use the one most suited to what you're trying to do. You don't get prizes for the fanciest, most complex way of writing code.

    If you're trying to round up to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 10:38 pm

    #1262034

  • RE: How to Make a Dynamic Stored Procedure Query

    only4mithunc (12/13/2010)

    Here my doubt is in this case as we are not able to use sp_executesql (due to the vary large length of the string), then how can we avoid...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 1:23 pm

    #1261915

  • RE: Is there a more efficent way

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 13, 2010 at 1:19 pm

    #1261911

Viewing 15 posts - 28,891 through 28,905 (of 49,552 total)