Forum Replies Created
Viewing 15 posts - 36,346 through 36,360 (of 39,903 total)
-
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
-
RE: SA password change
course you have to have the trace running. If you want to do this, set this up in a stored procedure, mark as a startup procedure, and then monitor and...
-
RE: Connection Dropping on with xp clients
Or it could be coding errors or network problems. I've been running XP, as are some others here and while we don't constantly make ODBC connections, I use QA, which...
Viewing 15 posts - 36,346 through 36,360 (of 39,903 total)