Forum Replies Created

Viewing 15 posts - 2,326 through 2,340 (of 2,458 total)

  • RE: Has SQL Query Termination (;) become mandatory in SQL Server 2012?

    I cannot find anything that states that it has become mandatory, but I did find someone claiming that the BOL for SQL 2008 (not R2) stated that it was...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 17, 2012 at 9:35 am

    #1569199

  • RE: Request

    Great Post!

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 13, 2012 at 8:43 pm

    #1568543

  • RE: Dynamic SQL

    Sean Pearce (12/11/2012)

    +1

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 13, 2012 at 4:27 pm

    #1568521

  • RE: No data showing up in a Database replication

    forceman29 (12/13/2012)

    I have a server 2008 R2 server were Database A is replicating to Database B. A full snapshot was done without any issues. I have the publication setup as...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 13, 2012 at 10:57 am

    #1568411

  • RE: Need a TSQL Book that I can expertise in writing Tsql

    I second all those that said Itzek Ben-Gan. There are some great stairways on this site. I would say that Greg Larson's Stairway to DML and Celko's Stairway to Data...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 13, 2012 at 9:47 am

    #1568384

  • RE: NEED HELP WITH RECURSIVE CTE

    capnhector (12/12/2012)

    This looks like a running total (from the math in the rCTE). Have a look at Jeff Modens article on the "Quirky Update" http://www.sqlservercentral.com/articles/T-SQL/68467/ It will at...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 12, 2012 at 6:07 pm

    #1568124

  • RE: NEED HELP WITH RECURSIVE CTE

    CELKO (12/12/2012)

    Read about the Window clause, which makes it very easy to write running totals:

    CREATE VIEW Running_Balance (payment_nbr, receipt_date, payment_amt, acct_balance)

    AS

    SELECT payment_nbr, receipt_date, payment_amt,

    ...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 12, 2012 at 5:25 pm

    #1568113

  • RE: 2012 Management Console

    Sean Grebey (12/11/2012)

    If I use 2012 Management Console from the Express version to Manage an Enterprise version of 2008, will things like Maintenance plans be available, or have those features...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 12, 2012 at 3:15 pm

    #1568081

  • RE: Microsoft Certified Solutions Associate (MCSA)

    sanandh87 (12/12/2012)

    Hi,

    ... and I need dump also.

    Thanks,

    Anandh

    I like this guy's blog and am using it to study for the SQL Serve 2012 certs. Note how he passed and why he...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 12, 2012 at 2:53 pm

    #1568078

  • RE: Need HTML T-SQL script to run scheduled job.

    SSIS is the best tool for this.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 12, 2012 at 1:51 pm

    #1568060

  • RE: Interview Questions

    Your Name Here (12/5/2012)

    Sorry to be a bit off-topic but this thread flashed me back to an interview I had years ago. The 'technical' questions about troubleshooting were surprisingly...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    December 5, 2012 at 6:54 am

    #1565737

  • RE: sp_executesql N'SELECT * INTO Error

    I want to start by saying that I am not providing an answer here but rather providing a little food for thought....

    All permissions are the same on both servers.

    But the...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 29, 2012 at 7:12 pm

    #1564120

  • RE: Splitting Strings Based on Patterns

    Great, great article Dwain. Amazing work and perhaps your best article yet on SSC IMHO (it's certainly your longest).

    I would have been delighted to propose a looping solution as...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 29, 2012 at 6:48 pm

    #1564114

  • RE: Keeping Current

    mike 57299 (11/28/2012)

    Hi All...

    ... As part of our backup plan, we do transaction log backups every hour during the work day.

    I would like to copy the logs to...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 28, 2012 at 4:05 pm

    #1563498

  • RE: create index on nvarchar value

    sa.ordekci (11/28/2012)

    ...As i know, indexed fields increase searching time. For example primary key.

    Indexes usually make queries faster. Primary keys usually make queries faster because an index is created when you...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 28, 2012 at 3:59 pm

    #1563496

Viewing 15 posts - 2,326 through 2,340 (of 2,458 total)