Viewing 15 posts - 45,871 through 45,885 (of 49,552 total)
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2008 at 3:04 am
The OS can swap SQL's memory allocations out to disk.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2008 at 12:49 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2008 at 12:47 am
This looks suspiciously like homework. Is that the case?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2008 at 12:29 am
Advice? Sure. Don't go that route.
You're adding complexity to the system with dynamic SQL and you're potentially openings a sQL injection vulnerability Dynamic SQL will require that the user has...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2008 at 12:17 am
How about you give us the entire requirement with several sample values and the results you want out?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2008 at 12:03 am
Mani Singh (7/7/2008)
the SPID are system SPID's, so better be carefull is you are thinking of using the Kill statement.
The system spids are the ones reporting the deadlock, not the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 10:34 am
Viewing 15 posts - 45,871 through 45,885 (of 49,552 total)