Viewing 15 posts - 25,036 through 25,050 (of 49,552 total)
Cool. Don't forget to rebuild indexes afterwards (any that are in the filegroup you shrunk)
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, 2011 at 7:05 am
Yes, shrinking generates log.
Why are you shrinking? Is there a really good reason?
p.s. SQL doesn't have incremental backups. You mean Diff? Those will be larger than normal because the shrink...
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, 2011 at 6:02 am
With an immense amount of difficulty.
SQL scales up, not out. If you do decide to go that route, you need some form of replication (probably peer-to-peer) and then implement your...
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, 2011 at 6:00 am
SELECT ... INTO is the 'simple' solution.
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, 2011 at 5:52 am
Oh, and just for anyone who has any remaining doubts (I know the references were poor, but MS isn't in the habit of specifying that features aren't dependant on recovery...
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, 2011 at 5:49 am
Just remember the scoping rules. If a temp table is created in dynamic SQL, it's only visible within that dynamic SQL and will be automatically dropped once that piece of...
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, 2011 at 5:19 am
During the setup, yes, but it's just the restores (full then log) needed for the setup.
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, 2011 at 5:18 am
10% free space is not much. It's pretty much what the DB engine needs for normal operation. I suggest you rather consider moving that DB to a new drive, splitting...
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, 2011 at 5:14 am
Truncate only will only work if the free space is at the end of the file. It probably isn't.
How much free space are we talking here? How much does your...
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, 2011 at 4:28 am
Jayanth_Kurup (7/7/2011)
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, 2011 at 2:02 am
Please explain clearer and in more detail with some table definitions.
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, 2011 at 1:58 am
Checksum. Detects far more problems than torn page ever could.
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, 2011 at 1:57 am
That's a little wide for a clustered index....
What's the table definition (create table statement) and what are some of the queries you are trying to optimise.
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, 2011 at 1:56 am
Go and ask him what he meant. It's the only way you're going to find out what he really wants.
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, 2011 at 1:50 am
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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, 2011 at 4:57 pm
Viewing 15 posts - 25,036 through 25,050 (of 49,552 total)