Viewing 15 posts - 36,751 through 36,765 (of 39,818 total)
Crystal sucks. Haven't used it in about 18 months, but for 10 years I've hated it.
Excel is ok, if it's text report, try to send Excel sheets since I can...
December 27, 2002 at 9:54 am
How big is this? Is it sensitive data? could you send it? (Pls reply before sending).
I'm surprised you can't attach with no log file, usually works, though suspect status may...
December 27, 2002 at 9:49 am
Not through SQL replication. DTS has a login transfer task that you could use.
There is also a createdate in syslogins that you could use to build something.
Steve Jones
December 27, 2002 at 9:47 am
Server might crash if you lose the array. If you're good with that, then no issues.
Steve Jones
December 27, 2002 at 9:45 am
I think there is an event that fires on login and you might be able to get something to work.
Instead, I'd write a job that scans sysprocesses every minute and...
December 26, 2002 at 9:25 am
I'd also bcp or DTS out the entire table to a text file to be sure you have it.
Then do a backup.
Then try rebuilding the clustered index (or creating one)....
December 25, 2002 at 4:24 pm
Happy holidays and I'd vote for Andy's solution. Much simpler to do.
Steve Jones
December 25, 2002 at 4:22 pm
Might want to also run Profiler and see what's hitting tempdb so hard.
Steve Jones
December 25, 2002 at 4:20 pm
What should happen:
User contacts SQL Server, sends credentials, SQL then verifies these with the DC and once verified, checks syslogins (and sysusers) for access before responding to the client.
Steve Jones
December 24, 2002 at 11:28 am
Sorry, not a cluster guy. Try to get Brian to look at this.
Steve Jones
December 24, 2002 at 10:07 am
Don't try to reinvent this. You will forget something and screw yourself.
Use VSS or CVS or some system designed to do this. Maintian strict controls on this.
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
Steve Jones
December 24, 2002 at 10:05 am
Get Brian Kelley's book for some ideas:
http://www.netimpress.com/shop/product.asp?product_id=NI-SQL2
Don't see too much on benchmarking per se. Probably should write something up on this.
Also:
http://www.sql-server-performance.com has lots of articles on perfromance tuning.
http://www.sqlservercentral.com/columnists/nboyle/memorytuning.asp
Steve Jones
December 24, 2002 at 10:02 am
There is a new security book from CurlingStone, SQL Server Security Distilled, that covers this in great detail. If it's taking significantly longer, you have network issues.
As Anatares said, once...
December 24, 2002 at 9:45 am
Most likely what you want to do is change your PK index to non clustered. High selectivity, etc. Not worth having the clustered. I'd move the clustered to the StartTime...
December 24, 2002 at 9:42 am
December 24, 2002 at 9:32 am
Viewing 15 posts - 36,751 through 36,765 (of 39,818 total)