Viewing 15 posts - 3,316 through 3,330 (of 9,720 total)
SQLMaister (10/15/2013)
Select count(*) is the most efficient and correct way.
Careful there. Absolute statements like this can get you into trouble in the DBA world.
The "correct way" depends on what you...
October 16, 2013 at 4:47 am
Charles Kincaid (10/15/2013)
Brandie Tarvin (10/15/2013)
October 16, 2013 at 4:45 am
Mighty (10/15/2013)
paul s-306273 (10/15/2013)
Who'd have thought count(*) would generate so much debate...
I agree, and that apparently nobody uses a where clause while counting, but that they only are interested in...
October 15, 2013 at 8:37 am
Interesting results on the execution plan. All plans but the COUNT() on Name came backup with only an expected 9B in the row size. The Name count came back much...
October 15, 2013 at 7:30 am
The best way I've found for using COUNT(MyCol) is to use either the identity column or the primary key column. That way there are no NULL results to worry about.
SELECT...
October 15, 2013 at 6:37 am
This is interesting. To install BOL, one has to go into the Help menu (Manage Help Settings) and choose from a whole bunch of different documents to download and install...
October 10, 2013 at 8:15 am
GilaMonster (10/10/2013)
Brandie Tarvin (10/10/2013)
GilaMonster (10/9/2013)
Brandie, do you have any writing tools that you'd recommend, for tracking characters, places, plot segments, stuff like that? Preferably for iPad and PC.
I use StoryBox...
October 10, 2013 at 6:59 am
Greg Edwards-268690 (10/10/2013)
Based on your reaction, there could be either a chuckle, or a spew on monitor moment.
Really? That explains the coffee leaking through the sides of the webcam. I...
October 10, 2013 at 6:45 am
GAH. I hate the Upgrade Advisor.
Analysis Complete. 4 Total. 3 Successes. 1 Warning.
The warning is the first action (Analyze SQL Server) and it makes me go to a report that...
October 10, 2013 at 6:11 am
Greg Edwards-268690 (10/10/2013)
Check this out.
So if anything, I would install afterwards.
Was it giving you a warning during installation of Dev Edition?
Or was...
October 10, 2013 at 6:02 am
I redownloaded the package and it seems (cross fingers) to be working this time. So maybe I hit the wrong one when I clicked download the first time.
Thanks, Sean.
October 10, 2013 at 5:55 am
Huh. This time I'm getting a different error than I did the first time. The first time was something like "Windows Installer is not the right installer for this program,"...
October 10, 2013 at 5:49 am
All,
I have gotten no responses to my SQL 2012 question here, so I'm going to post in the Thread.
Has anyone seen this problem before?
October 10, 2013 at 5:23 am
GilaMonster (10/9/2013)
Brandie, do you have any writing tools that you'd recommend, for tracking characters, places, plot segments, stuff like that? Preferably for iPad and PC.
I use StoryBox for PC (windows)....
October 10, 2013 at 5:13 am
jcrawf02 (10/9/2013)
This seems like an exceptionally bad idea to me.
1 - you wouldn't *have* a pacemaker if your heartbeat wasn't irregular, so how is that ECG going to be...
October 9, 2013 at 9:08 am
Viewing 15 posts - 3,316 through 3,330 (of 9,720 total)