Forum Replies Created
Viewing 15 posts - 5,671 through 5,685 (of 6,104 total)
-
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...
K. Brian Kelley
@kbriankelley -
RE: SQL "Worst Practice SA password"
drowssap is pretty easy, too.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
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).K. Brian Kelley
@kbriankelley -
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....
K. Brian Kelley
@kbriankelley -
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...
K. Brian Kelley
@kbriankelley -
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...
K. Brian Kelley
@kbriankelley -
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...
K. Brian Kelley
@kbriankelley -
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...
K. Brian Kelley
@kbriankelley -
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...
K. Brian Kelley
@kbriankelley -
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
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
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.
K. Brian Kelley
@kbriankelley -
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
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
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...
K. Brian Kelley
@kbriankelley -
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...
K. Brian Kelley
@kbriankelley -
RE: Are things THAT different than MS Access?
As has already been hit upon, if presenting examples, it's easier to give a person a bit of code to copy, paste, and execute rather than give a list of...
K. Brian Kelley
@kbriankelley
Viewing 15 posts - 5,671 through 5,685 (of 6,104 total)