Viewing 15 posts - 331 through 345 (of 417 total)
Grant Fritchey (2/18/2015)
Maybe I missed the .sql on the second one. It had the standard name for a window. My bad.
Yeah, my eyes aren't what they used to be either....
February 19, 2015 at 10:03 am
PHYData DBA (2/19/2015)
ChrisM@Work (2/19/2015)
DonlSimpson (2/18/2015)
...I think it's just lazy though.
When "lazy" translates to "quick, easy and accurate" it's not so bad.
That statement says it all.
It is a perfect example...
February 19, 2015 at 10:01 am
CELKO (2/18/2015)
I need to create random alphanumeric characters as primary key values when inserting a record [sic]. .. I don't want to use GUID or auto increment integer...
February 19, 2015 at 9:09 am
PHYData DBA (2/18/2015)
Eric M Russell (2/18/2015)
Resender (2/2/2015)
I always do
WHERE 1 = 1
I can't remember where I picked this...
February 18, 2015 at 3:11 pm
Grant Fritchey (2/18/2015)
One difference between...
February 18, 2015 at 1:55 pm
aaron.reese (2/8/2015)
@joe, it would be lovely to live in your SQL bubble where all RDMS is built and managed by people with 20 years experience, a masters degree...
February 10, 2015 at 10:15 am
wannabe1 (1/14/2015)
i wanna wait for some time(seconds) to get a delta on resources and i want it as a function to sort based on columnsthanks for the reply.
What does...
February 9, 2015 at 11:41 am
CELKO (2/2/2015)
And thanks to your bad...
February 2, 2015 at 4:08 pm
Sean Lange (1/30/2015)
Or even this:
select count(1/0) from myTable
Ooo, I like that! That could break somebody's brain when they stumbled up it.
This is cool to the appropriate nerds too:
select count(distinct...
January 30, 2015 at 3:52 pm
mark.finch (1/30/2015)
and what about Count(0) ? Is that the same result as Count(1)?
ANY literal value, or non-column name value, acts exactly the same as count(*).
select count(*) from myTable
select...
January 30, 2015 at 3:41 pm
Phil Parkin (1/27/2015)
DonlSimpson (1/27/2015)
January 28, 2015 at 3:03 pm
Any idea why the first query (the one with the parameters) shows a Query cost (relative to the batch): 100%, and the second 0% ? The difference narrows slightly...
January 28, 2015 at 9:32 am
I know this is fairly radical, but I enforce an alphabetic order to the column list in the schema. My only concession is pk first.
I got an...
January 27, 2015 at 8:22 am
I use ID unless it is followed by another word, e.g. memberIdHistory
January 22, 2015 at 11:26 am
Viewing 15 posts - 331 through 345 (of 417 total)