Viewing 15 posts - 45,886 through 45,900 (of 49,571 total)
Firstly, you're on 32 bit. Unless you have AWE enabled and the /pae switch in boot.ini, SQL can only use 2 GB max. that would explain why so little memory...
July 8, 2008 at 7:30 am
Jeff Moden (7/8/2008)
Based on what I've seen in real life at work...5% Newbie
60% casual knowledge
10% good knowledge
5% DBA quality
5% Developer quality
5% Hybrid quality
10% Stupid or dangerous or both
I'd probably scale...
July 8, 2008 at 6:03 am
Grant Fritchey (7/8/2008)
GilaMonster (7/8/2008)
"We fixed it. No thanks to you."I can't honestly say that I wouldn't have hit the guy. Nice exercise in restraint.
I very nearly put the pizza I...
July 8, 2008 at 5:38 am
Mark Horninger (7/8/2008)
Jeff,Was it a test DB with space issues? Dunno why anyone would want do do that....
Mark
I think it was a posting on these forums. Stick...
July 8, 2008 at 5:11 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic529875-338-1.aspx
July 8, 2008 at 4:44 am
I don't think you can create new DTS packages. If you have the DTS designer components you can modify existing packages
July 8, 2008 at 4:42 am
Why do you have to use a stored proc? bcp is about the best solution to this kind of problem. DTS packages work too.
How many rows are we talking about?...
July 8, 2008 at 4:37 am
Plase post table structure, sample data (as insert statements) and desired output.
See - http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 8, 2008 at 4:33 am
Can you run profiler against the server and look at exactly what reporting servces is doing and how long the queries take?
July 8, 2008 at 4:18 am
If you've already deleted the table, the transaction's useless as your delete has already committed. For next time, look up BEGIN TRANSACTION in books online.
As for the 3rd party tools,...
July 8, 2008 at 4:13 am
Hav you checked your disks? Check the physical disk counter in perfmon.
Avg sec/read, avg sec/write % idle time.
Run profiler for a bit, catch the slow runnig queries. See if the...
July 8, 2008 at 3:48 am
The database you are restoring to must have nobody using it. All users reading it will have to disconnect (or their connections be killed) before you can restore the log.
July 8, 2008 at 3:11 am
Depends. If you explicitly started a transaction before runningthe command, you can just run ROLLBACK. My guess however is that you didn't start a transaction. In that case there's no...
July 8, 2008 at 3:04 am
Grant Fritchey (7/7/2008)
I quit.
I don't blame you.
My worst (and it wasn't all that bad) was the previous bank I worked at. We went through three IT Dept heads in 10...
July 8, 2008 at 12:47 am
Viewing 15 posts - 45,886 through 45,900 (of 49,571 total)