Viewing 15 posts - 45,271 through 45,285 (of 49,552 total)
The only thing I have ever seen blocked by a log backup, was a full/diff backup, and that was on SQL 2000. But you can test it out for yourself,...
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
August 2, 2008 at 12:03 pm
Hmmm, I wonder how filtered indexes (SQL 2008) would work for a column with severe data skew. Create one index for the 'common' data values and another for the 'rare'...
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
August 2, 2008 at 11:43 am
If you don't like using the profiler GUI, you can use the sp_trace stored procedures. Easiest way is to generate the trace definition from profiler. Create the trace then script...
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
August 2, 2008 at 9:42 am
If you're close to getting the MCDBA (one exam away) perhaps try to finish it. If not maybe consider doing the 2005 certs instead, or perhaps even going straight for...
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
August 2, 2008 at 9:28 am
I thought much the same on that particular post, though there may be history that we don't know of. The other authors are fine (imho)
I think you'll appreciate the latest...
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
August 2, 2008 at 9:25 am
Marios Philippopoulos (8/2/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
August 2, 2008 at 5:48 am
Grant Fritchey (8/2/2008)
Well, not to give competition to Steve... OK, it won't, but there is
I love that blog. Just wish it was updated more often.
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
August 2, 2008 at 3:46 am
Ankit Mathur (8/2/2008)
I actually wanted to avoid using SHRINKFILE option. Is there any other way to reclaim OS space. I read somewhere it should not be a preferred mode.
Nope. 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
August 2, 2008 at 3:44 am
Alvin Ramard (8/1/2008)
I can't help but wonder if the view definition looks something like:create view vwProviderDirectoryReportWithAllServiceLocations
as
Select *
From
ProviderDirectoryReportWithAllServiceLocations
end
Or
create view vwProviderDirectoryReportWithAllServiceLocations
as
Select *
From
...
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
August 2, 2008 at 3:43 am
Ankit Mathur (8/2/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
August 2, 2008 at 2:43 am
Paresh Randeria (8/1/2008)
Let me clarify......It's the production database so FULL Recovery Model required and also we replicate tables too...
But if you're not backing the log up, what's the point...
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
August 2, 2008 at 1:53 am
Have a look at this, see if it helps you at all
Something else for you to try. I hope you're comfortable with command line tools
Open two command prompts on...
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
August 1, 2008 at 2:18 pm
Starting SQL with -f works too. Had to do that once with a failed login trigger on a cluster. The DAC was set local only.
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
August 1, 2008 at 1:59 pm
riga1966 (8/1/2008)
on Windows 2000 server where SQL Server 2005 runs it doesn't mean
you're automatically granted the same kind of permissions on SQL...
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
August 1, 2008 at 1:43 pm
Try starting the server in minimal config. From the command prompt
sqlservr.exe -f
I think that may allow the service to start. I know there's one switch that allows SQL to start...
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
August 1, 2008 at 1:21 pm
Viewing 15 posts - 45,271 through 45,285 (of 49,552 total)