Viewing 15 posts - 31,651 through 31,665 (of 39,819 total)
Do you mean a single disk of a R-5 array?
We've had notifications set up before in software to notify administrators. At the least this should be written to the Windows...
August 17, 2007 at 11:01 am
I don't think that's an accurate count. If you check the properties of each database, you will see the size and space available. The difference is your data, index, and...
August 17, 2007 at 9:48 am
You can do things like
select venue, date, avg(los)
from table
group by venue, date
Are the dates really dates only or are times in there. You might be able to clean...
August 17, 2007 at 9:43 am
I guess I wasn't thinking of just bad code, but decent code you write to get a job done. We all could stand our code to be tuned to some...
August 17, 2007 at 6:37 am
Sorry to hear that David and good luck taking it again. Definitely spend some time just doing stuff in SSMS, add users, permissions, etc. Just talk through exercises and get...
August 16, 2007 at 8:51 pm
Didn't know the plates stayed with the car. That's interesting.
In VA and CO, when you sell the car, you remove the plates immediately. They are yours. The new owner must...
August 16, 2007 at 4:52 pm
Anders brings up a good point, and one I'm addressing now. What happens if Steve leaves
(I'm not planning on it).
Everyone should have...
August 16, 2007 at 9:12 am
Anders,
I guess I'd disagree on this. You should be allowed to go to court, but the film and record of the camera is evidence. I think you're responsible for your...
August 16, 2007 at 8:59 am
The summary is that if you have un-authenticated users, meaning not in your AD forest, you need a processor license. If you have employees or partners, with AD accounts, you...
August 16, 2007 at 8:22 am
Yep, steve_smith, of (steve) Smith and Jones fame, hit it. It should run a little faster if that field is indexed and it's used.
August 16, 2007 at 8:21 am
TheSQLGuru has the best reason. The old syntax will get dropped.
I think the inner join syntax reduces mistakes and it's easier to read, but that's personal preference. I never had...
August 16, 2007 at 8:20 am
Actually in SQL Server, a system backup of the host Windows system wouldn't get the databases. The files would be locked, so without a database backup plan by the DBA,...
August 16, 2007 at 8:14 am
Are you looking at the right dates? Meaning are there multiple dates in the table and the one in the WHERE clause is the right one?
It worked for me as...
August 16, 2007 at 8:10 am
Sounds more like you want some sort of SSIS package. The header row with rowcount will be slightly tricky. You need this info first, so it's probably two queries you're...
August 16, 2007 at 8:06 am
Viewing 15 posts - 31,651 through 31,665 (of 39,819 total)