Forum Replies Created

Viewing 15 posts - 16 through 30 (of 120 total)

  • RE: Creating schemas

    Nice Question.Thanks Steve

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    March 3, 2015 at 2:10 am

    #1781282

  • RE: Thanksgiving 2014

    Thanks Steve.

    Just extended your query to identify current years thanksgiving day:

    declare @date datetime

    set @date=dateadd(yy,0,getdate())

    SELECT DATEADD( DAY, 5-datepart(dw,DATEADD( WEEK, -1, DATEADD( MONTH, 11, DATEADD(yy, datediff(yy, 0, @date), 0)))), DATEADD( WEEK,...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    February 6, 2015 at 4:48 am

    #1776011

  • RE: Duplicates

    Thanks Steve...

    Just to add one point here:

    Windows functions can be used directly in SELECT and ORDER BY Clauses only..

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    February 5, 2015 at 3:44 am

    #1775619

  • RE: Getting Distinct

    Good question...

    Back to basics

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    February 2, 2015 at 10:20 pm

    #1774935

  • RE: Group By, Count, and NULLs

    Good Question...

    That's why I prefer using count(1)

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    February 2, 2015 at 9:56 pm

    #1774931

  • RE: The PIVOT

    Nice Question!

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 29, 2015 at 12:55 am

    #1773900

  • RE: SQL date code question

    or something like:

    SELECT *

    FROM vm

    WHERE vm.visit_date between DATEADD(DAY,1,EOMONTH(CURRENT_TIMESTAMP,-2)) AND

    CURRENT_TIMESTAMP-1;

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    January 29, 2015 at 12:35 am

    #1773894

  • RE: tabular model cube

    I see Other place where Microsoft is referring tabular database as cube.

    in SSDT,right click your tabular project>Properties>Under Deployment server

    I see "model" as cube name..

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 3, 2014 at 12:18 am

    #1726687

  • RE: tabular model cube

    Thanks a lot Koen

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 1, 2014 at 10:15 pm

    #1726372

  • RE: tabular model cube

    Koen,I second that tabular model database is not a cube..

    But I am seeing some Microsoft guys using word "tabular cube"

    http://blogs.msdn.com/b/andreasderuiter/archive/2012/12/10/should-you-use-a-data-warehouse-with-a-tabular-cube.aspx?CommentPosted=true#commentmessage

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 1, 2014 at 6:34 am

    #1726149

  • RE: How to delete data from multiple tables at a time

    or try creating triggers

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 11, 2014 at 3:16 am

    #1720680

  • RE: Non clustered Index taking up more space than data

    is your table compressed?

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    May 27, 2014 at 6:33 am

    #1716662

  • RE: COUNT, COALESCE, ISNULL, DISTINCT

    Good Question ,,Thanks Steve

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    November 19, 2013 at 4:22 am

    #1667350

  • RE: Oracle and MS SQL server Database performance check

    Also try attunity connector for oracle source.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    October 11, 2013 at 3:18 am

    #1657833

  • RE: Hekaton

    Koen Verbeeck (10/4/2013)

    Easy one thanks!

    (it's also the only useful new feature in SQL 2014 so far)

    In SQL server 2014,Microsoft seems to be mainly banking on Hekaton (In-memory) feature + Hadoop...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    October 5, 2013 at 9:37 pm

    #1656140

Viewing 15 posts - 16 through 30 (of 120 total)