Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 3,221 total)

  • RE: delete records from table2 that are not in table1

    To properly assist you with tested T-SQL please post table definition(s), sample data and desired results.

    To do so please click on the first link in my signature block for a...

    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]

    March 17, 2011 at 2:38 pm

    #1300224

  • RE: timeout error.

    Try this

    Instead of changing the execution time-out through Tools -> Options you should be able to specify it when opening the first query/connection to a SQL Server in the "Connect...

    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]

    March 17, 2011 at 2:07 pm

    #1300208

  • RE: How to Import Data from a Data file having multiple Delimeters ?

    What method are you utilizing to attempt to import the file SSIS or OPENROWSET or BCP?

    Not knowing that, but here are some ideas which might spark your thinking.

    1. ...

    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]

    March 17, 2011 at 10:34 am

    #1300061

  • RE: Check Constraint or Update Trigger?

    Have you considered creating a VIEW which would contain only those records that could be edited?

    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]

    March 16, 2011 at 6:40 pm

    #1299749

  • RE: SQL Deprecated Features

    Try this T-SQL

    SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%deprecated%')

    and/or read this:

    http://msdn.microsoft.com/en-us/library/ms186265.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]

    March 16, 2011 at 1:06 pm

    #1299606

  • RE: Is Table Space = Data Space + Index Space?

    To better understand the space taken by indexes, and thier usefulness in finding data in a table may I suggest your read this article:

    http://www.simple-talk.com/sql/performance/lipoaspiration-in-your-sql-server-database/?utm_source=simpletalk&utm_medium=email-main&utm_content=Lipaspiration-20110307&utm_campaign=SQL

    If by "data space" you mean the...

    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]

    March 16, 2011 at 12:37 pm

    #1299583

  • RE: CONVERT function

    tilew-948340 (3/15/2011)

    bitbucket-25253 (3/15/2011)

    As we all do ... let me challenge you .. submit a good QOD, you will be surprised at what you learn, quote]

    Submit a QOD, even a bad...

    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]

    March 15, 2011 at 8:15 pm

    #1299191

  • RE: Order by columns NOT NULL

    now you have me completely confused as to what it is you need ..

    Sample of the log file with the info in my previous post

    (Order,Point Name,Duration) with R1:

    1 Point2...

    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]

    March 15, 2011 at 7:31 pm

    #1299186

  • RE: CONVERT function

    tilew-948340

    But it does not realy matter anyway because the reason for the "question of the day" is not the points but the fun of learning... I learned something, so I...

    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]

    March 15, 2011 at 7:25 pm

    #1299183

  • RE: How to script a remove 'IDENTITY(1,1)'

    a column with an IDENTITY

    yes each value is unique wether it is defined as a primary key, index or whatever.

    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]

    March 15, 2011 at 11:24 am

    #1299011

  • RE: How to script a remove 'IDENTITY(1,1)'

    Before making the change that the customer is requesting.

    As an IDENTITY the each value is unique.

    1. What would be the possible adverse effects if duplicate values are...

    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]

    March 15, 2011 at 10:22 am

    #1298962

  • RE: Single Procedure To Update One Column in Any Table

    This undocumented procedure (spMSforeachtable) might be what you need.

    http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

    http://weblogs.asp.net/nunogomes/archive/2008/08/19/sql-server-undocumented-stored-procedure-sp-msforeachtable.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]

    March 15, 2011 at 10:07 am

    #1298954

  • RE: calculating dates

    timotech (3/15/2011)

    Thanks Guys, you are all very correct, everything works very fine. Thanks

    Thank you, for letting all who answered know that you have been helped. It is appreciated.

    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]

    March 15, 2011 at 7:20 am

    #1298829

  • RE: SQL Script to check SQL Server cluster Nodes.

    Here we go again -- the specified as correct answer is an item to be depreciated in a future release of SQL Server and one possible answer, and the one...

    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]

    March 14, 2011 at 9:15 pm

    #1298649

  • RE: CONVERT function

    tilew-948340 Posted Today @ 8:51 PM

    I gues I just had to not take a chance and do not answer it, but for the futur, if at least we don't loose...

    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]

    March 14, 2011 at 7:26 pm

    #1298639

Viewing 15 posts - 1,366 through 1,380 (of 3,221 total)