Forum Replies Created

Viewing 15 posts - 961 through 975 (of 1,415 total)

  • RE: Login options

    Hany Helmy (2/5/2015)


    Ed Wagner (2/5/2015)


    Stewart "Arturius" Campbell (2/5/2015)


    Never created login for asymetric key before, so learned something new.

    Me either. Good question.

    On the contrary 4 me, I knew this one...

  • RE: Parameter Sniffing or Something else?

    dwain.c (2/4/2015)


    patrickmcginnis59 10839 (2/4/2015)


    dwain.c (2/4/2015)


    Sounds like a problem I had recently and the same solution too.

    SQL Query invoked by Crystal Reports v9.2 Performance Issue

    I'm a great believer in going with...

  • RE: Parameter Sniffing or Something else?

    dwain.c (2/4/2015)


    Sounds like a problem I had recently and the same solution too.

    SQL Query invoked by Crystal Reports v9.2 Performance Issue

    I'm a great believer in going with what works, without...

  • RE: doubt on include column

    vignesh.ms (2/4/2015)


    Hi There ,

    All non-clustered-index (NCI) will also store the key column of clustered-index(CI)

    While creating the NCI, if we intentionally include the key column what would happen, is that occupy...

  • RE: Won't convert to decimal

    ma701ss (2/3/2015)


    I've just imported everything in my XML file as varchar and then managed to convert some of the fields to Decimal(18,2) in SQL Server Management Studio however some apparently...

  • RE: Normal Data

    Wayne West (2/3/2015)


    Sigerson (1/29/2015)http://en.wikipedia.org/wiki/Abraham_Wald

    I loved this! Thanks for including it. Now, if I could only learn to code more like this.

    What, your databases aren't regularly exposed to anti-aircraft...

  • RE: Won't convert to decimal

    ma701ss (2/3/2015)


    OK but like I said it stops inserting before the first record and I presume it's to do with the characters in the field of the first row. I...

  • RE: Field as Group header

    you should check out how to post questions, including table definitions, sample data in a ready to use format.

    I've done similar queries like so (not sure if it would work...

  • RE: Zero out backup files?

    ok, I can see that restores take advantage of instant initialization, but thats because its again (re)creating database data files *from* the backup. Since SQL won't do instant initialization on...

  • RE: Zero out backup files?

    Where do you see backups taking advantage of instant file initialization? Your post implies that this is the case based on your reading, and it would be interesting to read...

  • RE: Normal Data

    One of my favorite stories about decisions based on data!

    Wald applied his statistical skills in World War II to the problem of bomber losses to enemy fire. A study had...

  • RE: Getting Distinct

    Carlo Romagnano (1/23/2015)


    Extremely easy!

    Why do people get it wrong?

    I expected 100% of correct answers!

    😀

    I miss many of them, I don't google them before answering, nor do I try running them...

  • RE: Custom SSMS

    I'm pretty much the opposite, I try to keep my SSMS in original condition and often do query editting in notepad++.

  • RE: Extra line creap in while opening script in SQL Server 2012

    I have observed this behavior, I just remove it if I remember to, I just think its a bug that slipped through.

  • RE: Hadoop and SQL Server

    Eric M Russell (1/15/2015)


    patrickmcginnis59 10839 (1/15/2015)


    Eric M Russell (1/15/2015)


    Robert.Sterbal (1/14/2015)


    I think some of those geeks would also say that they want to supplant Microsoft licensing from their data.

    Microsoft handles...

Viewing 15 posts - 961 through 975 (of 1,415 total)