Forum Replies Created

Viewing 15 posts - 5,596 through 5,610 (of 7,613 total)

  • RE: database growth

    SQL also creates internal tables for certain types of data, including: primary XML indexes,

    service broker, change tracking and a few other things. You'll need to include the size...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 3, 2014 at 10:44 am

    #1762464

  • RE: Baffling query plan on slow query

    Robert Frasca (12/2/2014)

    Grant Fritchey (12/2/2014)

    ScottPletcher (12/2/2014)

    Robert Frasca (12/2/2014)

    ScottPletcher (12/2/2014)

    Robert Frasca (12/2/2014)

    ScottPletcher (12/1/2014)

    I guess the SourceFactTimeCard table is fairly wide?

    I suggest creating a covering index on:

    SourceFactTimeCard (...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 2, 2014 at 12:00 pm

    #1762195

  • RE: Baffling query plan on slow query

    Robert Frasca (12/2/2014)

    ScottPletcher (12/2/2014)

    Robert Frasca (12/2/2014)

    ScottPletcher (12/1/2014)

    I guess the SourceFactTimeCard table is fairly wide?

    I suggest creating a covering index on:

    SourceFactTimeCard ( TimecardIndex, EmployeeID )

    If SQL then...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 2, 2014 at 10:36 am

    #1762169

  • RE: SQL DBA knowing user passwords

    eric.notheisen (12/2/2014)

    In our company sharing user passwords is a firing offense. As developers needing to troubleshoot user defined defects, we restore the production database to our development VM's and...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 2, 2014 at 9:07 am

    #1762131

  • RE: Baffling query plan on slow query

    Robert Frasca (12/2/2014)

    ScottPletcher (12/1/2014)

    I guess the SourceFactTimeCard table is fairly wide?

    I suggest creating a covering index on:

    SourceFactTimeCard ( TimecardIndex, EmployeeID )

    If SQL then uses that covering...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 2, 2014 at 8:43 am

    #1762119

  • RE: Auto Memory control

    SQL allows you to designate a proc(s) as "start up" procs that automatically runs when an instance starts. I was suggesting you create such a proc, or add code...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 2, 2014 at 8:40 am

    #1762114

  • RE: Baffling query plan on slow query

    I guess the SourceFactTimeCard table is fairly wide?

    I suggest creating a covering index on:

    SourceFactTimeCard ( TimecardIndex, EmployeeID )

    If SQL then uses that covering index -- it...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 1, 2014 at 4:43 pm

    #1761901

  • RE: Last 30 days aggregate query

    SELECT CONVERT(varchar(10), DATEADD(DAY, DATEDIFF(DAY, 0, dt), 0), 120) AS dt, SUM(amt) AS Amt

    FROM @t

    GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, dt), 0)

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 1, 2014 at 4:26 pm

    #1761900

  • RE: Proper use of CTE in scalar valued function

    You can pass @StartingDate as a param to the ITV function.

    Also, you can simplify the calc for PastPeriods:

    MONTH(@StartingDate) % 3 + 14

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 1, 2014 at 4:21 pm

    #1761899

  • RE: Auto Memory control

    You'll need to create a start up proc for each instance that checks for the different conditions.

    Since you have to change both instance's memory settings, I'd create a proc in...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 1, 2014 at 4:12 pm

    #1761898

  • RE: Alter the schema from one view causes the need to alter the other

    ZZartin (12/1/2014)

    ScottPletcher (12/1/2014)

    GilaMonster (11/30/2014)

    river1 (11/28/2014)

    What do you mean by stop using select?

    I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 1, 2014 at 3:22 pm

    #1761890

  • RE: Alter the schema from one view causes the need to alter the other

    GilaMonster (11/30/2014)

    river1 (11/28/2014)

    What do you mean by stop using select?

    I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and you won't...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 1, 2014 at 2:24 pm

    #1761873

  • RE: How to free up the drive space in SQL that has data files

    Also, as additional stop-gap measures:

    1) review indexes to see if there any you can drop

    2) if you have any heaps, see if they consume a lot of space beyond what...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    December 1, 2014 at 11:59 am

    #1761834

  • RE: tempDB queries

    zedtec (11/25/2014)

    I've also noticed when I go into my tempDB database properties through SSMS I get the following error:

    ERROR 1222 : Lock request time out period exceeded.

    I killed a session...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    November 25, 2014 at 9:52 am

    #1760866

  • RE: Find Values Like Field Values

    In theory, the code below would do what you've described.

    select t2.*

    from Table2 t2

    where

    exists(select 1 from table1 t1 where t2.detail like '%' + t1.ID +...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    November 25, 2014 at 9:47 am

    #1760864

Viewing 15 posts - 5,596 through 5,610 (of 7,613 total)