Forum Replies Created

Viewing 15 posts - 316 through 330 (of 626 total)

  • RE: Index question

    Tac11 (5/10/2016)

    IN GENERAL, Since 0 users seek,high users_lookups and high users_update, should PK be removed?

    You'll end up trading key lookups for RID lookups which are the same as far as...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 10, 2016 at 1:47 pm

    #1877949

  • RE: Index question

    Tac11 (5/10/2016)

    I have a table with 8 million rows (index size 1.5 GB and Data space 1.3 GB). when I ran index_usage_stats results came with

    Index id = 1 (datatype...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 10, 2016 at 9:45 am

    #1877877

  • RE: Are the posted questions getting worse?

    Trying to institute culture change is probably the hardest things I've ever had to do.

    They might not like it but...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 10, 2016 at 8:22 am

    #1877800

  • RE: Disabled jobs and jobs with no schedule.

    In my experience I've seen many create one schedule for each job. However, 1 schedule can have many jobs associated with it. As you observed nothing stops you...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 9, 2016 at 8:24 am

    #1877490

  • RE: Substring for column

    jollyegeorge (5/6/2016)

    I get error for 'Invalid object name 'dbo.DelimitedSplit8K'

    Yes it does, all the summary line has these bold values.

    It's a custom function that you have to create on your...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 6, 2016 at 1:05 pm

    #1877257

  • RE: Substring for column

    Here is a simple example on how to grab ALL text before the semicolon. Just keep in mind this implies that there will always be a semicolon to use...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 6, 2016 at 12:06 pm

    #1877233

  • RE: Substring for column

    Just Arthritis? After the semicolon perhaps? This is easy to do but I don't want to give you a bad solution. Please provide sample data and how...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 6, 2016 at 11:33 am

    #1877224

  • RE: Pros/Cons between Default vs Named Instances

    Note: This is a very old thread.

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 6, 2016 at 11:29 am

    #1877223

  • RE: T-SQL for Sync SQL Agent Jobs between Instances

    Did you just try right clicking on a job and select 'Script Job as' option?

    It won't help you with synching jobs but that's not something I would normally want to...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 6, 2016 at 11:21 am

    #1877219

  • RE: Cycle Through Multiple db's For EXISTence of a Table then DELETE

    Sean Lange (5/4/2016)

    Be careful using sp_msforeachdb. It can sometimes skip databases. Even more shocking is many of the major players don't really know why. http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

    Thanks for the tip! I've...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 4, 2016 at 1:15 pm

    #1876716

  • RE: Cycle Through Multiple db's For EXISTence of a Table then DELETE

    If you are asking if it's a good idea to use 'sp_msforeachdb' you just have to keep in mind that it's an undocumented procedure. So you never know how...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 4, 2016 at 9:45 am

    #1876650

  • RE: how to trim away the first 'x' and last 'y number of characters from a string

    Do you care about running that against any other possible db's? You might want something a little more generic.

    DECLARE @strings TABLE (LoginID VARCHAR(100))

    INSERT INTO @strings

    VALUES ('adventure-works\peter0'), ('Northwind\mary0'), ('Test\mark1')

    SELECT

    SUBSTRING(LoginID,CHARINDEX('\', LoginID)...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 4, 2016 at 9:25 am

    #1876642

  • RE: SQL version

    You can also pull all kinds of useful information from SERVERPROPERTY.

    SELECT

    SERVERPROPERTY('ProductVersion') AS ProductVersion,

    SERVERPROPERTY('Edition') AS Edition

    If you don't know the product name from the major builds versions you can always check...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 2, 2016 at 12:11 pm

    #1875979

  • RE: Count the number of hours between two dates

    Luis beat me to the sample data speech...but that being said I would advise not to use ordinal position in your ORDER BY clause. It's a bad habit to...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 28, 2016 at 2:08 pm

    #1875395

  • RE: Subscription notifications similar to Reddit

    Steve Jones - SSC Editor (4/28/2016)

    Notification icon where?

    Heck it doesn't even need to be an icon...just something like 'Notifications (3)' to indicate 3 new responses for example. Could be...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 28, 2016 at 12:21 pm

    #1875365

Viewing 15 posts - 316 through 330 (of 626 total)