Forum Replies Created
Viewing 15 posts - 37,081 through 37,095 (of 39,520 total)
-
RE: Microsoft - Love 'em or Hate 'em?
They are. I think the message is out that security and stability are more important than features. Notice .NEt server went RC1 the other day. Was supposed to be gold...
-
RE: Cleaning Bad Database Design
I tend to do this on an ongoing basis. To revisit an entire design is not usually practical or possible given uptime needs.
In my last job, we would contstantly identidy...
-
RE: Null User
There is a syslogins table in master. It may be materialized, so do not use EM. Use Query Analyzer to run "select * from syslogins"
A domain group is an NT...
-
RE: Review: Microsoft Baseline Security Analyzer
Amazing. I was just starting to use this to get a feel for my new environment and, while not perfect, it handled a number of my needs. I guess it's...
-
RE: Searching for old posts
Good enhancement. We'll add it to the list.
Steve Jones
-
RE: Fault Tolerant Strategy?
Andy is correct. The main issue for me has been that I may rollover to another system and then want that to be the primary until I decide to move...
-
RE: What is the difference between SET and SELECT?
I don't think there is a performance difference, but I could be wrong.
Steve Jones
-
RE: DTS - How to Handle Column Name Changes
Not that I know of. I think you will have to go through each one.
Steve Jones
-
RE: Delete selected?
Aha! I see your issue. Sorry
What you need to do is capture the msgID from msgPopup. Then delete the MsgInfo table and finally the msgPopup (or...
-
RE: DBCC ReIndex via Maintenance Plan
Skip this in the maintenance plan and write a job to do this directly.
Steve Jones
-
RE: Relational Database Without Relations
I sort of like the idea, though I tend to agree with the posters about the downfalls.
However, the intermediate table used to relate items and allow flexibility is a technique...
-
RE: Fault Tolerant Strategy?
I prefer log shipping or some variant I've developed. Easier to roll over/back to me, but I'm not a replication fan.
Steve Jones
-
RE: Parsing a delimited varchar column
Now that be slick!
Steve Jones
-
RE: Parsing a delimited varchar column
You could use a while loop to build the results, but it might be ugly if this is large.
I'm sure there is something, but can't think off the top of...
-
RE: Delete selected?
If these are in two tables, then you need two delete statements.
To delete the msgPopup,
delete msgpopup
FROM msgPopup INNER JOIN msgInfo
ON (msgPopup.msgID = msgInfo.msgID)
INNER JOIN msgMessage
ON (msgInfo.msgID = msgMessage.msgID)
WHERE
Sender...
Viewing 15 posts - 37,081 through 37,095 (of 39,520 total)