Viewing 15 posts - 1,846 through 1,860 (of 7,483 total)
GilaMonster (3/18/2015)
Koen Verbeeck (3/18/2015)
you can create a new non-clustered index on ID and GPSTime.This, assuming there aren't any other indexes which we haven't been shown
No, better to just add...
Tom
March 28, 2015 at 6:46 pm
ChrisM@Work (3/26/2015)
mister.magoo (3/26/2015)
ChrisM@Work (3/26/2015)
Phil Parkin (3/26/2015)
dwain.c (3/26/2015)
Gary Varga (3/26/2015)
dwain.c (3/25/2015)
Make it Work, Make it Fast,...
Tom
March 28, 2015 at 6:16 pm
dwain.c (3/26/2015)
Gary Varga (3/26/2015)
dwain.c (3/25/2015)
Make it Work, Make it Fast, Make it Pretty[/url]
Maybe I should...
Tom
March 28, 2015 at 6:13 pm
Phil Parkin (3/13/2015)
I've just had this one in SSIS:
Executing the query "exec ..." failed with the following error: "Package...
Tom
March 28, 2015 at 5:31 pm
How many of my databases have used GUIDs? A couple that I inherited did but they don't now, so none. Do I look at what my databases need...
Tom
March 28, 2015 at 5:08 pm
I'm feeling a bit of an idiot for responding to posts that were 5 years ago - oh, well, never mind. And thank heaven's for Paul with his insertion...
Tom
March 28, 2015 at 4:23 pm
Jeff Moden (10/27/2010)
Paul White NZ (10/26/2010)
So, does anyone know of an article that guarantees that ethernet addresses a globally unique because that's the only way such a guarantee could be...
Tom
March 28, 2015 at 12:57 pm
David Walker-278941 (10/12/2010)
As for the "are there that many" question, it's interesting to use an identifier that is essentially infinite.
Essentially infinite is way over the top. Maybe we...
Tom
March 28, 2015 at 12:15 pm
SanDroid (10/12/2010)
Tom
March 28, 2015 at 11:21 am
A lot of people have suggested that there's some sort of conflict between efficiency and effectiveness, mostly suggesting that doing something ineffectively but fast is efficient. I don't agree...
Tom
March 27, 2015 at 9:21 pm
skeleton567 (3/26/2015)
Tom
March 27, 2015 at 7:28 pm
Ray Herring (3/24/2015)
When SQL2005 introduced VarChar(max) I encouraged Devs to adopt the new data type immediately and most did. Eventually, we decided...
Tom
March 27, 2015 at 5:01 pm
When used properly and well written, triggers are extremely useful; when used inappropiately they are awful; when written badly they are awful; when they are both used inappropriately and written...
Tom
March 27, 2015 at 4:26 pm
I'm a bit surprised that the editorial seems to suggest that separating database and app releases is something new, because in fact it's something that has been around and recognised...
Tom
March 27, 2015 at 4:19 pm
PHYData DBA (1/26/2015)
Another reason why SELECT * from <any object> should never be used in application execution code.
Nonsense. The only reason you ever need to ban SELECT * from...
Tom
March 27, 2015 at 3:37 pm
Viewing 15 posts - 1,846 through 1,860 (of 7,483 total)