Forum Replies Created

Viewing 15 posts - 1,771 through 1,785 (of 2,462 total)

  • RE: How to return top n and sum up the rest

    This is a little ambiguous. Can you post an example of what you want?

    "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 10, 2015 at 9:27 am

    #1776670

  • RE: Report definition has an invalid target namespace

    Can you post one of the new RDL files?

    "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 10, 2015 at 8:55 am

    #1776656

  • RE: doubt on sql server

    djj (2/10/2015)

    Alan.B (2/10/2015)

    This code will create a heap:

    CREATE TABLE dbo.T1 (col1 int primary key)

    A clustered index is a "table" that is sorted by a specific key or combination of keys.

    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

    February 10, 2015 at 8:23 am

    #1776641

  • RE: Report definition has an invalid target namespace

    This could be a lot of things causing the problem but the issue is with the resulting XML name spaces in your new reports. If your XML knowledge is good...

    "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 10, 2015 at 6:58 am

    #1776617

  • RE: doubt on sql server

    what is the difference between clustered and non clustered index

    This is a big topic and there's plenty of people on SSC that can answer this in detail. I think it's...

    "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 10, 2015 at 6:41 am

    #1776609

  • RE: Which Datawarehouse Books good to read

    Eirikur beat me to it but I was going to say

    The Microsoft Data Warehouse Toolkit, 2nd Edition

    [/url]. This is the geared towards data warehousing in Microsoft environments specifically. If...

    "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 10, 2015 at 6:07 am

    #1776596

  • RE: Traversing down a tree

    Quite frankly, I had to read it a few times to get it. It is extremely well-written but the subject matter is a bit heavy in my opinion. Well worth...

    "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 9, 2015 at 3:20 pm

    #1776501

  • RE: I want to be certified SQL developer, what to do?

    I have not passed the test yet but have been studying for it and think this book is really good:

    Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit)

    I would...

    "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 9, 2015 at 3:17 pm

    #1776500

  • RE: I want to be certified SQL developer, what to do?

    CooLDBA (2/9/2015)

    Start with Exam 70-433 - TS: Microsoft SQL Server 2008, Database Development

    https://www.microsoft.com/learning/en-us/exam-70-433.aspx

    Wrong version (the link is for 2008, this is a 2012 forum.

    "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 9, 2015 at 3:10 pm

    #1776498

  • RE: Traversing down a tree

    I periodically have to do this kind of thing. Take a look at:

    Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] by Jeff Moden. This has...

    "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 9, 2015 at 3:09 pm

    #1776497

  • RE: Save each report page as a seperate file

    The first thing that comes to is to save the the report as a PDF and then use some kind of utility that splits the PDF into seperate files. There's...

    "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 9, 2015 at 12:42 pm

    #1776477

  • RE: regarding sql developer

    You might find this helpful.

    Sample Resume: SQL Developer[/url]

    "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 9, 2015 at 11:10 am

    #1776461

  • RE: What's a good indexing strategy for this situation?

    Dave-148053 (2/5/2015)

    I am most often returning all the columns in the table.

    As far as the primary key, that's part of my "what's a good strategy" question. Should I be...

    "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 5, 2015 at 4:35 pm

    #1775923

  • RE: What's a good indexing strategy for this situation?

    What columns are you returning? And why no primary key? The first index you need is a clustered index...

    Edit: Added question about PK.

    "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 5, 2015 at 4:02 pm

    #1775917

  • RE: Passing Malformed email address to Send Mail Task

    This is a duplicate post. Active thread can be found here:

    http://www.sqlservercentral.com/Forums/Topic1658159-3412-1.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 5, 2015 at 3:40 pm

    #1775912

Viewing 15 posts - 1,771 through 1,785 (of 2,462 total)