Forum Replies Created

Viewing 15 posts - 11,101 through 11,115 (of 14,953 total)

  • RE: Look Up database

    Not entirely clear on what you mean.

    If you have one database that needs to exist on multiple servers, you can use replication or log shipping to keep them in synch....

  • RE: Guest Editorial: Do DBAs Need a Code of Ethics?

    Brad's comment about a mission statement, even one worded as a code of ethics, or vice versa, would definitely be of use to people new to the profession. Would...

  • RE: Missing Index DMVs not sync

    Have you read the MSDN article on using that query? It's entirely possible it simply doesn't have the data in it that you are looking for.

  • RE: How To find 0 KB files in a folder

    You could define a CLR that would check filesize for you. Or an ActiveX script that could be run as part of an SSIS package. CLR would be...

  • RE: SQL or Oracle

    David Portas (2/5/2009)


    GSquared (2/5/2009)


    The Berkley DB (which is what Rel is based on) is not relational. It stores data as key-value pairs without relations. Yes, Rel may be...

  • RE: Failing views

    Can you run a select on the data you are trying to pull from the remote server? Just that part of the view by itself, I mean.

  • RE: What do you do with a new SQL Server?

    frank.morales (2/5/2009)


    Great article but my problem is this, "I'm new SQL and just loaded SQL 2005 and what/how do I do next?" I can read the article but it doesn't...

  • RE: Database renamed accidently

    Open Management Studio, click on a database name. Then click on it again. Then hit the 1 key on your keyboard. It'll try to rename the database....

  • RE: Bulk insert won't skip the column header in the .csv file

    I could be wrong, but it looks like your column definitions won't find the Name column correctly, because you define it as having quotes around it but it doesn't. ...

  • RE: How do I share Data Mining Models with end users?

    Reporting Services has a number of ways to publish data. Is that what you're looking for?

  • RE: Using Script Task to check if Folder Exists

    There's an option in SSIS file system tasks to not create the object (file or folder) if it already exists. Will that do what you need?

  • RE: Guest Editorial: Do DBAs Need a Code of Ethics?

    Jeff Moden (2/5/2009)


    The ironic part about this whole discussion is that a code of ethics would only be followed by ethical people. 😉

    True.

    And even professions with published ethics rules...

  • RE: Installation of SQL server 2000 on Vista

    The configuration manager you found in the start menu is just a limited client tool. Certainly installed because of an application.

    The way to tell if you have SQL Server...

  • RE: Rebuild Index Task Failure

    Have you run an integrity check on the database? That's where I'd start with what you're describing.

  • RE: UNION and UNION ALL

    Christopher Stobbs (2/5/2009)


    So it's more that the UNION is not that good rather than UNION ALL is not that good.

    So UNION ALL is ok basically if needed?

    Either is okay...

Viewing 15 posts - 11,101 through 11,115 (of 14,953 total)