Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 2,458 total)

  • RE: Are the posted questions getting worse?

    djj (2/16/2016)

    Alan.B (2/16/2016)

    Lynn Pettis (2/16/2016)

    The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants...

    "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

    February 17, 2016 at 6:32 am

    #1859236

  • RE: Windows Functions: Tell me when that changes.

    hartmann 74688 (2/17/2016)

    Just to make it clear, they are windowing functions or window functions.

    Windows functions sounds like API of the OS :).

    Good Article, great reminder!

    I noticed that too (and...

    "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

    February 17, 2016 at 5:48 am

    #1859226

  • RE: I want to automate my database compression , can anyone provide me the T sql code...

    Note the section titled "Using Transact-SQL" in this link: Enable Compression on a Table or Index

    "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

    February 16, 2016 at 10:15 pm

    #1859172

  • RE: Return multiple values in a one column preformatted string

    If there is a possibility that OccurrenceTypeName will contain any of what SQL Server considers XML characters (e.g. CHAR(1) through CHAR(32), CHAR(38), CHAR(60) or CHAR(62)) then you would make a...

    "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

    February 16, 2016 at 10:13 pm

    #1859171

  • RE: Replace Cursor with alternative solution

    There is no reason you should need a cursor here or any other form of RBAR solution for this. Based on a quick look at what you're trying to do...

    "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

    February 16, 2016 at 9:54 pm

    #1859168

  • RE: Index for VARCHAR field

    SQL!$@w$0ME (2/16/2016)

    Hi Folks:

    For VARCHAR field, non-clustered index or full-text index recommended. When should we use full-text index.

    Any guidance/thoughts much appreciated.

    Many thanks!

    Why do you think you need any index on 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

    February 16, 2016 at 9:37 pm

    #1859167

  • RE: Reports taking too much time from application

    EasyBoy (2/16/2016)

    We have few (2-3) reports which are run by users through application everyday in the morning.

    Through SQL profiler i found those queries (dynamic SQL), which are running through SQL...

    "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

    February 16, 2016 at 9:29 pm

    #1859165

  • RE: SQL Query to Extract after 2nd - in a field

    and most people helping on forums aren't being paid

    Huh?!?! I just thought my SSC paycheck was really late. Aw man!

    "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

    February 16, 2016 at 8:56 pm

    #1859163

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/16/2016)

    The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants of 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

    February 16, 2016 at 11:41 am

    #1859055

  • RE: Datetime Parameter Default

    Luis Cazares (2/16/2016)

    For this particular case, there's a simpler solution using common date routines[/url]

    SELECT

    StartTime = DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), -.25), -- 6PM yesterday

    EndTime ...

    "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

    February 16, 2016 at 11:17 am

    #1859046

  • RE: Datetime Parameter Default

    I prefer to use T-SQL for this type of thing. The way I would do this is:

    1) Create a Dataset named something like DS_DateDefaults (use whatever matches your naming convention)

    2)...

    "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

    February 16, 2016 at 10:38 am

    #1859036

  • RE: Holidays and Calendar Generation

    Interesting article. Well done sir.

    "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

    February 16, 2016 at 8:05 am

    #1858989

  • RE: Are the posted questions getting worse?

    For those of you who are into quantum mechanics...

    IT'S OFFICIAL: Gravitational waves have been detected, Einstein was right

    "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

    February 11, 2016 at 3:03 pm

    #1858205

  • RE: Is monitoring production servers allowed using a Developer Edition?

    Microsoft actually allows you to chat with their licensing specialists online. It's been a few years but I have used this service and found them quite helpful.

    http://blogs.technet.com/b/volume-licensing/archive/2011/11/23/click-to-chat-now-on-microsoft-com-licensing.aspx

    "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

    February 2, 2016 at 8:03 am

    #1855990

  • RE: Are the posted questions getting worse?

    BL0B_EATER (1/29/2016)

    Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?

    During some tough projects I...

    "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

    January 29, 2016 at 2:04 pm

    #1855394

Viewing 15 posts - 1,006 through 1,020 (of 2,458 total)