Viewing 15 posts - 42,121 through 42,135 (of 49,552 total)
Domagoj Orec (12/27/2008)
My goals would be:1. Close my buisness and leave this God forbidden country (Croatia)
2. Find a good job somewhere like Australia, UK or Canada 😀
Why don't you come...
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
December 27, 2008 at 1:33 pm
Well, DBCC certainly is old. Some of the commands have been around since SQL 6, but then that's true for a select statement too.
Many of the DBCC statements are deprecated...
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
December 27, 2008 at 1:27 pm
Jeff Moden (12/27/2008)
BWAAA-HAAA! Excellent candidate for this year's SQL Darwin award...
He's a repeat offender who just doesn't seem to get it. I have several unpleasant memories of that guy's...
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
December 27, 2008 at 12:14 pm
leonp (12/27/2008)
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
December 27, 2008 at 12:08 pm
leonp (12/27/2008)
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
December 27, 2008 at 10:09 am
Lots more. See - http://www.microsoft.com/learning/mcp/certifications.mspx
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
December 27, 2008 at 3:27 am
Reindexing is not going to fix this. There's corruption in the data pages (index id 0). If it was only in the nonclustered indexes (index id 2 and higher) then...
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
December 27, 2008 at 3:23 am
jananik (12/27/2008)
But I think I had taken the backup in a single destination only.
Did you backup using the management studio gui? If there were two files listed in 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
December 27, 2008 at 3:10 am
I posted a link to a doc about tran log management earlier in the thread.
GilaMonster (12/22/2008)
Take a read through this - http://www.sqlservercentral.com/articles/64582/
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
December 27, 2008 at 3:01 am
You're pulling the entire of two tables, amounting to a total of 15 million rows. That's never going to be quick and there's no way indexes are going to help...
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
December 27, 2008 at 3:01 am
GilaMonster (12/23/2008)
Have you looked through Books Online, specifically the sections on SSIS?
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
December 27, 2008 at 2:57 am
Paresh Prajapati (12/26/2008)
Take transaction log backup of database and apply on that server with recovery.
How's that going to help with creating a second copy of an in-recovery database without breaking...
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
December 27, 2008 at 2:55 am
Pavas Malviya (12/26/2008)
c++ is bad. But good at c#
But you can't write extended procs (as far as I know) in C#.
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
December 27, 2008 at 2:53 am
leonp (12/24/2008)
We have perfmon running for 3 hours; thrice a day. Sampling once every 75 seconds. Is that a bad thing?
Not perfmon. Profiler.
Select * for the reader (which 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
December 24, 2008 at 7:34 am
Michael Earl (12/24/2008)
At least they were able to open Management Studio and run the query.
Well there was this one guy (who claimed to be a performance tuning guru and have...
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
December 24, 2008 at 7:33 am
Viewing 15 posts - 42,121 through 42,135 (of 49,552 total)