Forum Replies Created
Viewing 15 posts - 36,211 through 36,225 (of 39,771 total)
-
RE: Is there a way to tell who dropped a table?
As far as I know, Log Explorer is the only retroactive way to do this.
Steve Jones
-
RE: Change licensing mode
I think you must install again, but that's not too dificult a process, just time consuming.
Steve Jones
-
RE: Current Activity/Process Info sorting
This data is mostly from sysprocesses with joins to syslogins, etc.
You could get it from QA and then sort it.
Steve Jones
-
RE: Search String on HomePage
-
RE: How long would a backup take?
Two words: SQL Litespeed.
http://www.sqlservercentral.com/columnists/sjones/sqllitespeedlightningfastbackups.asp
http://www.sqllitespeed.com/slsdefault.asp
Is the db 30GB or the backup file? no that it matters, neither should take 15 hours. If the DBAs need some help, sjones@sqlservercentral.com, US$100/hour, 4 hour...
-
RE: Dynamic Views
Personally I'd write multiple views to cover the possibilities. How often would they change? If it's not that often (you have to judge that), I'd then just hit the right...
-
RE: How much do you earn?
Droppinbg back a bit, my tax rate is US 35% (my wife works), not sure about the state rate in CO. Hell, I'm not against taxes, they allow me to...
-
RE: workflow dictated by returned values?
Not that I know. The only way I've found is to use an Active X Task to call the sproc and then alter the package dynamically or use the Active...
-
RE: In the Real World - Lost Data Chains
I would have expected this as well.
Oh well.
Steve Jones
-
RE: DBA in PHX
eljeffo,
apologies if you didn't like the responses. We do moderate some posts if we think they are flames. Keep in mind your post is kind of "in your face" and...
-
RE: Not in
Try
select
a.*
from tablea a
left outer join table c
on a.col1 = c.col1
where c.col1 is null
Might not be...
-
RE: Master server vs. Target server
maybe a rename? That REALLY screws up master servers and one reason why I don't use them.
Steve Jones
-
RE: Stored Procedure ?
create procedure MyProc
@empid int
as
select * from emp where empid = @empid
Steve Jones
-
RE: Dynamic Views
Why do you need to insert a where clause into the view? Define the view without it and insert the where clause into your query of the view.
Steve Jones
Viewing 15 posts - 36,211 through 36,225 (of 39,771 total)