Forum Replies Created

Viewing 15 posts - 226 through 240 (of 392 total)

  • RE: SSMS & Database snapshot

    Sorry, this is not a very good question. I got it right, only because I assumed that the writer of the QOD meant to infer that there is a wizard...

  • RE: Unique constraint on a nullable column

    SanDroid, I was wondering when you were going to show up;-)

    (I need to get mine back as well:hehe:)

  • RE: sys.syscomments

    Jeff

    Many languages, when they compile the code, strip out comments as wasted space.

    Agreed - but these are not comiled apps. Before you say it, I know that many HTML generators...

  • RE: Unique constraint on a nullable column

    Good question - thought about it until it hurt:hehe:

    Why would you want to use a where clause to enforce uniqueness? That one stumps me. Otherwise, I agree with the rest...

  • RE: sys.syscomments

    Tom

    Another reason not to use sys.syscomments and use sys.sql_modules instead (the type of the definition column of sys.sql_modules is nvarchar(max)).

    This isn't what the question is. Additionally, maybe if the question...

  • RE: sys.syscomments

    Imran

    Northwind is normally associated with SQL Server 2000 and below.

    Unless you performed an upgrade from 2000, in which case the database would be upgraded to the next version as well.

  • RE: sys.syscomments

    Good question, and actually makes one think a little.

    Tom

    If you've never seen any comments in there I don't want you writing any stored procedures or triggers in my shop!

    Kind...

  • RE: Dynamic Sql QUERY To use Dynamic openrowset

    Is the startup service of all of your SQL Servers the same and are they Domain Admin?

    What is the permission level of the account calling the stored procedure?

  • RE: Dynamic Sql QUERY To use Dynamic openrowset

    We have the same issue, rougly 80 servers on the network, and each needs to be able to pass data to the HQ.

    What we do - declare a variable for...

  • RE: T-SQL GO statement

    Mike, good question. I guessed at the answer and learned something new.

    Thanks

  • RE: Reading SQL Server's Transaction Log

    Fat Wallet

    From the perspective of a professional DBA and Dev, this is useless. First, it is troublesome. Second, it cannot guarantee pulling data correctly. Third, it does not give enough...

  • RE: Column Order in an Index

    Sarvesh, This was a good article, with the potential to be much better if you were to expand on it. You leave out a lot of why things work this...

  • RE: SELECT INTO with a Temp Table

    Excellent question on a topic which is such a problem. I see this a lot from developers who wonder why it won't work. At first glance, it looks like it...

  • RE: Data Typing Quandry

    Excellent question - got it wrong but learned something new. It's going to be a great day:hehe:

  • RE: Shared or dedicated storage

    Everyone seems to think that if one throws a big collection of disks at this and then uses virtual raid it will meet the IO requirements, I am not too...

Viewing 15 posts - 226 through 240 (of 392 total)