Forum Replies Created

Viewing 15 posts - 181 through 195 (of 323 total)

  • RE: Copy partition data on OLTP 24x7 instance

    Follow up to my above post, here's my code

    Create Table

    CREATE TABLE TestPartition15m(

    [Id] [BIGINT] NOT NULL,

    [DateCreated] [DATETIME2](3) NOT NULL,

    [Amount] [INT] NOT NULL,

    [SupplierId] [INT] NOT NULL,

    [PartitionId] AS (CONVERT([TINYINT],ABS(DATEDIFF(DAY,CONVERT([DATE],'20000101',(112)),[DateCreated])%(14))+(1),(0))) PERSISTED NOT NULL,

    ...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 21, 2014 at 10:44 am

    #1731088

  • RE: Back from Sabbatical

    Glad to say hi to you at SQLBits.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 21, 2014 at 5:55 am

    #1730967

  • RE: Transactional replication with updatable subscription

    How are you observing data mismatch?

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 21, 2014 at 5:06 am

    #1730956

  • RE: Moving a database from sql server 2005 to a new VM

    Joy Smith San (7/18/2014)

    Just one more thing. Any sample WBS template for this acitvity ?

    Thanks.

    Hi Joy

    A quick google search brings up plenty of samples (Office/Excel templates) that you can tweak...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 18, 2014 at 2:12 am

    #1730514

  • RE: Developers vs. DBAs

    Eirikur Eiriksson (6/12/2014)

    Eric M Russell (6/12/2014)

    Hollywood should make a film called "A Day Without a DBA" just to show the ignorant public (and cocky app developers) what a total global...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 17, 2014 at 9:30 am

    #1730327

  • RE: Moving a database from sql server 2005 to a new VM

    Don't forget any deprecated features or code. (And any DTS packages!)

    There is a Technical Upgrade to SQL 2008 R2 ref guide here.

    Edit: since you going P2V, you may want...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 17, 2014 at 7:51 am

    #1730247

  • RE: Space Hoarders

    In my travels as a contractor/freelance DBA I have lost count of the times I have tried to explain to a SAN/Storage admin that databases GROW, some faster than others...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 16, 2014 at 10:12 am

    #1729924

  • RE: Anyone going to SQL Bits 17-19 June Telford ICC, UK

    Going to this also (Friday & Saturday), so looking forward to meeting fellow DBAs and learning a bunch of stuff.

    Be nice to meet Steve Jones, (and say thanks for publishing...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 14, 2014 at 8:33 am

    #1729148

  • RE: Thinking outside the box on table partitioning

    BobMcC (7/3/2014)

    Yes, it's a DW environment. However our current business practice of how we load data and report off it don't lend itself to one of the perks of partitioning;...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 14, 2014 at 4:44 am

    #1729091

  • RE: Backup and Restoration Issue...

    Beatrix Kiddo (7/10/2014)

    The same user has thanked me as a man too :-D. It's just nice when people say thank you.

    Indeed, no offense intended.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 10, 2014 at 5:50 am

    #1728344

  • RE: Backup and Restoration Issue...

    Chowdary's (7/10/2014)

    Thank you Mr.Gail Shaw...

    😀

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 10, 2014 at 5:20 am

    #1728325

  • RE: Whats the best way to move replication to the new sever ?

    MysteryJimbo (7/10/2014)

    If only it was that simple. What about registering the publisher at the distributor? Enabling replication on the new publisher? Simply restoring with keep_replication will not...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 10, 2014 at 3:02 am

    #1728299

  • RE: Doing healthcheck on 40+ SQL Servers centrally.

    Joy Smith San (7/8/2014)

    Thanks.

    Do you have any such sample powershell script by any chance ?

    Kindly share if you have any handy.

    If you do a simple google search Joy, I...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 9, 2014 at 4:01 am

    #1727973

  • RE: Details to collected from sql servers for upgrading to 2012 version.

    +1 for Upgrade Advisor. You have not really specified any details as towards your existing servers, eg - are they OLTP? Or OLAP? How often are they going...

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 8, 2014 at 7:21 am

    #1727757

  • RE: How to get started with freelancing database projects ?

    http://www.freelancer.com

    Caveat: I have never used the above site, but looking at the project offers it would seem that is what the OP is requiring.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

    July 8, 2014 at 5:29 am

    #1727717

Viewing 15 posts - 181 through 195 (of 323 total)