Forum Replies Created
Viewing 15 posts - 5,671 through 5,685 (of 6,105 total)
-
RE: Exam 70-228
Are you looking for test simulation software or are you looking for an actual platform in which to play with queries and the like? I'm assuming the former. ...
-
RE: Are things THAT different than MS Access?
EM can be used to create database tables and it works well enough. However, there are other products out on the table that do a lot more.
This goes back...
-
RE: SQL "Worst Practice SA password"
drowssap is pretty easy, too.
K. Brian Kelley
-
RE: How have you improved the SQL Servers at your work
quote:
I also helped architect an inhouse data center as opposed to colo or managed. Went from $6k/month costs to < $3k (US). -
RE: SQL "Worst Practice SA password"
From the newest SQL Server Magazine UPDATE newsletter:
quote:
A final note: Oops! Last week's worst-practices commentary contained aone-word typo that had major ramifications....
-
RE: Inconsistent Trigger
It very well could, yes, especially since you're going to see quite a bit of lock escalation if you are also making updates row by row. However, if the...
-
RE: How have you improved the SQL Servers at your work
Actually, it's all contained within a DTS package at the present time. The tables for servers to check, reporting outages, and determining which servers notify which people are in...
-
RE: Help, Cannot restore Translogs correctly!
How much time occurs between the full backup and the first transaction log backup? Also, unless the backups were one right after the other, could any nonlogged operations such...
-
RE: Are things THAT different than MS Access?
I don't think there are a whole lot, either. Most of the DBAs around me operate from EM. I usually have QA open (EM not necessarily so) so...
-
RE: How have you improved the SQL Servers at your work
A couple of simple things:
1) Wrote a "heartbeat" check program that makes an ADO connection to each SQL Server every hour. Production servers are reported to the DBAs and...
-
RE: SQL Server 2000 Log File Backup and Truncation
Correct. It is necessary on SQL 7. SQL 7 doesn't do the dummy records automatically.
K. Brian Kelley
-
RE: Understanding NULL in SubQueries
quote:
USE NorthwindGO
SELECT CategoryName
FROM Categories
WHERE EXISTS (SELECT NULL)
ORDER BY CategoryName ASC
GO
and how the (SELECT NULL) comes into play.
-
RE: Dynamic SQL and Temp table creation
What error are you getting?
The code create a global temporary table without issue on my system.
K. Brian Kelley
-
RE: Understanding NULL in SubQueries
Mr. Travis is correct in that it will return the number of rows, all having NULL to be checked by the EXISTS() function, matching the parameters of the query contained...
-
RE: Make sure your Host backs up SQL!!!
Sounds like they covered their legal bases with their Terms and Conditions. This isn't surprising nowadays. With respect to a hosting solution, I don't have any experience with...
Viewing 15 posts - 5,671 through 5,685 (of 6,105 total)