Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 8,754 total)

  • RE: Today's Random Word!

    DonlSimpson (9/21/2015)

    Ed Wagner (9/21/2015)

    whereisSQL? (9/19/2015)

    djj (9/18/2015)

    DonlSimpson (9/18/2015)

    Luis Cazares (9/18/2015)

    Stuart Davies (9/18/2015)

    djj (9/18/2015)

    BL0B_EATER (9/18/2015)

    whereisSQL? (9/18/2015)

    Luis Cazares (9/18/2015)

    BL0B_EATER (9/18/2015)

    anthony.green (9/18/2015)

    BL0B_EATER (9/18/2015)

    Ed Wagner (9/18/2015)

    anthony.green (9/18/2015)

    Stuart Davies (9/18/2015)

    Eirikur Eiriksson (9/18/2015)

    SQLRNNR (9/17/2015)

    DTA

    distrust

    circumspect

    reckless

    Driving

    Fast

    Limit

    stop

    GO

    Green

    Hornet

    Sting

    Police

    Roxanne

    Cyrano

    Nose

    Pick

    Peck

    Bushel

    Deadweight

    September 21, 2015 at 10:28 am

    #1828152

  • RE: Memory-optimized queries using table scan instead of seek

    Grant Fritchey (9/21/2015)

    There are only 38k distinct values in a data set of 25 million. Add to that the fact that you're selecting a broad swath of those values. Assuming...

    September 21, 2015 at 8:34 am

    #1828098

  • RE: XML Validation of multiple elements in one step

    BOR15K (9/21/2015)

    Hello,

    Can one advise if it is possible to fully validate an XML file based on its XSD Collection please?

    I do have an XSD Collection myCollection and then I validate...

    September 21, 2015 at 2:55 am

    #1828014

  • RE: save real datatype in sql without converting to exponential

    bkshn (9/21/2015)

    Hello

    I want to save 999999999 as real data in sql.

    but it saved 1+E09.

    Could you help me how can I save 999999999?

    thanks alot

    Quick question, do you need an actual number...

    September 21, 2015 at 2:20 am

    #1828006

  • RE: Error message while taking backup

    OS: Windows 2003 Enterprise x64 Edition

    SQL :MS SQL Server 2005 SP3

    That's quite an antique collection you got there, not certain if the backup is your real problem!

    😎

    Is the third party...

    September 20, 2015 at 12:52 pm

    #1827966

  • RE: Help with small recursive numbers table

    thomashohner (9/20/2015)

    Hello All,

    I am trying to do a very small numbers table to compare A1c's against. However I am running into a issue when recursion hits the number 2.27 it...

    September 20, 2015 at 12:45 pm

    #1827965

  • RE: Development Environment for Linux Developers accessing SQL Server

    Quick thought, I've used free tds, http://www.freetds.org/ for years, many of my workstations are Linux/Unix and freetds provides the equivilent of sqlcmd, works quite well (most of the time:-D). Does...

    September 20, 2015 at 11:35 am

    #1827957

  • RE: Are the posted questions getting worse?

    Is anyone memory optimized?

    😎

    September 20, 2015 at 10:11 am

    #1827947

  • RE: Memory-optimized queries using table scan instead of seek

    I've reproduced the 64/65 split using a small set of 1,000,000 rows with much higher duplication on the key than in your set, roughly 4 times higher. The difference between...

    September 20, 2015 at 9:57 am

    #1827946

  • RE: Pattern Matching in SQL Server

    Jason A. Long (9/20/2015)

    Eirikur Eiriksson (9/20/2015)

    Quick question Jason, can you post the source for the dbo.SplitCSVToTable8K function?

    😎

    It's simply a renamed version of Jeff Moden's DelimitedSplit8k function. It was renamed to...

    September 20, 2015 at 5:51 am

    #1827940

  • RE: Pattern Matching in SQL Server

    Jason A. Long (9/19/2015)

    I won't call this an elegant solution by any stretch of the imagination, but it's the only "1:00 am" solution that's coming to mind at the moment...

    IF...

    September 20, 2015 at 1:51 am

    #1827927

  • RE: Error 833 : trigger the error

    vijayu (9/20/2015)

    Hi,

    I tried so hard to recreate the error 833, through simulation using different suggested method. But was not successful. Can I manually add it in the error log of...

    September 20, 2015 at 1:45 am

    #1827924

  • RE: Memory-optimized queries using table scan instead of seek

    My suspicion is that this has more to do with the selectivity, that is the number of duplicate key values in the nonclustered index.

    😎

    What is the output of this query?

    SELECT

    ...

    September 20, 2015 at 1:31 am

    #1827923

  • RE: Table locking while insert statement

    shamshad.ali (9/18/2015)

    I have two tables for insertion in one transaction scope. Table one have 10 rows. After first table insert statement (not yet committed) if I run select on first...

    September 19, 2015 at 10:52 am

    #1827897

  • RE: CPU load history

    ANn -425914 (9/18/2015)

    Is there a query to get CPU load history for the past 6 months or so for a SQL server?

    Thanks,

    No, the stats are accumulative, you will have...

    September 19, 2015 at 9:22 am

    #1827894

Viewing 15 posts - 4,486 through 4,500 (of 8,754 total)