Viewing 15 posts - 45,286 through 45,300 (of 49,571 total)
Please don't post in all capitals. It's the online equivalent of shouting at someone.
First thing is to find out why the procedure is slow. Are there cursors, while loops or...
August 7, 2008 at 3:25 am
Not within one instance. SQL treats all databases equally. If you need to do this, and the databases don't refer to each other, you could install a second instance and...
August 7, 2008 at 3:08 am
siddartha pal (8/5/2008)
Thanks alot for the inputs. There is lot of material available on net and its difficult for me to know which one is good.
Most of the free...
August 7, 2008 at 3:02 am
Manie Verster (8/2/2008)
Heh, heh, heh I have a surprise for you!!! I am a developer and proud of it.
Guess what. You ain't the only one.
I do hope there...
August 2, 2008 at 1:18 pm
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,...
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'...
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...
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...
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...
August 2, 2008 at 9:25 am
Marios Philippopoulos (8/2/2008)
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.
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...
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
...
August 2, 2008 at 3:43 am
Ankit Mathur (8/2/2008)
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...
August 2, 2008 at 1:53 am
Viewing 15 posts - 45,286 through 45,300 (of 49,571 total)