Forum Replies Created

Viewing 15 posts - 5,161 through 5,175 (of 6,041 total)

  • RE: Alternative option to UNION ALL

    sqldba_newbie (4/23/2012)


    GSquared (4/23/2012)


    I'd have to see the reason for the Union All statements (evident from the query, most likely) to be more specific, but if it's all coming from one...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Social Media and Interviews

    Straight up, I wouldn't consider a job that required special access to my Facebook account (I don't have one) or personal life. That's just a red flag... coming from the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Career Advice - SQL Server Development ---Please Help!

    Carlaabanes (4/23/2012)


    hi, how 'bout in my case? i wanna go back to being an sql ninja in the back seat. you see i was a dot net developer for some...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: sql server admin books

    selvakumar.sms (4/17/2012)


    hi all

    i am very new to sql server admin. so please suggest some very good books and sites to learn basic and advance of sql...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Do not grant any permissions to create or modify database objects

    srik.kotte (4/17/2012)


    Can anyone help me with this...I searched in google but I couldn't find any solution..Please help..

    Thanks

    You can use the xp_logininfo procedure to returns information about Windows users and Windows...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Search billions of records from multiple tables

    You mentioned that you've been using Text Search engine in the past, so this advice assumes that at least some of your routinely searched terms are contained in text columns....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Which user is this?

    shahgols (4/16/2012)


    Thank you very much for that information!

    I have already created that user using code, and it still cannot log in...that's what I see in SQL Server logs. It's...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: SSIS skips random rows from an Excel file

    I hate working with Excel as a datasource. Business users love it, because it's easy to enter data and the design is flexible. However it's problematic when used in an...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Running same SQL code against a number of tables

    Daryl Lloyd (4/16/2012)


    ...

    b) use a view to union all the tables together and query that instead [drawbacks - our tables are stored in separate database instances and cannot be indexed,...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Primary with Null value

    sukato7 (4/14/2012)


    How can I set PK columns to allow null or blank?

    A primary key column can't contain NULL. It would be like a street with no name or a product...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Best of the Best

    TravisDBA (4/17/2012)


    Hmmmm. I look at the 2007 Top 100 list on that site and I noticed that Microsoft (correct me if I'm wrong) is not on that list. No big...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Audit (extended stored procedures permission)

    Select permission on some extended stored procecures and system tables is required for basic connectivity, especially when users are connecting via the ODBC driver. Whatever permissions that SQL Server 2005+...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Best of the Best

    Companies tend to lavish more attention and rewards on whatever department is integral to their core business model. For example, you can have a showroom floor full of fat and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Linked server to MySQL Server.

    I have a question for someone here who has experience with MySQL. I've heard that with MySQL, there are are options for multiple table storage types, one of which is...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: SQL 2005 Table keeps being deleted

    Pete.murray (4/2/2012)


    Thanks for the reply guys,

    GilaMonster - I think you gave me the perfect direction to investigate in, I can see all the information I need to identify the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 5,161 through 5,175 (of 6,041 total)