Viewing 15 posts - 3,676 through 3,690 (of 7,504 total)
We use the same attitude Grant Fritchey posted.
To support your "support teams" requirements to be able to restore any backup on any given time and database, I would provide them...
June 10, 2009 at 2:09 am
Without knowing the tb / ix definitions and stats, i would say to modify all in-lists to @temp objects and rewrite to join with those ! (of use a split-function...
June 10, 2009 at 1:43 am
Hmm ... Books online is a good resource to figure this out.
But anyways...
If you can, create a last Log backup !
then:
hmm ...
1) restore the latest FULL backup with...
June 10, 2009 at 1:29 am
You should install SSIS server components to schedule the package!!
Apparently adding SQL2008 (devedtn + bids) messed up my settings.
I'll have to figure out a workaround.
June 9, 2009 at 7:11 am
This kind of message also occurs if sqlserver cannot take the extend of a db file with a timeout periode.
The extend will still be taken by the os, but sqlserver...
June 8, 2009 at 1:30 am
Jeffrey did a good job explaining some of the most primary hits most of us suffered with 64-bit. 😎
One thing I would like to add: Don't enable AWE ! 64-bit...
June 8, 2009 at 1:25 am
srikant maurya (6/8/2009)
try below sql statment with admin permisionupdate sc
set sc.name=replace(sc.name,' ', '')
from sys.syscolumns sc,sys.sysobjects so
where so.id=sc.id and so.type ='u' and charindex(' ',sc.name)>0
--and so.name='table_name'
If I'm correct this will no...
June 8, 2009 at 1:12 am
One ambiguity overhere:
- are you talking of white spaces in the column names ?
- are you talking of white spaces in the columns content ?
To alter the column names, you...
June 8, 2009 at 1:11 am
There is a reason for the dependency of sqlserver instances vs drives !
Why are you tempted to avoid this dependency ?
June 8, 2009 at 1:07 am
One of the most important advantages of filegroups comes from a DRP context.
Partial availability: (EntEdtn / DevEdtn)
The only thing of a db you need is the primary filegroup ...
June 6, 2009 at 1:04 pm
If you created your new non-clustering index without specifying a filegroup, you should see a parallel execution for that query, because will actually put this index on a per content...
June 5, 2009 at 3:18 am
Your issue ( select max(the_clustered_pk_column) ) is the cause of your huge consumption.
It actually performs the full clustered index datapage level scan !!!!
This is an issue of SQLServer in the...
June 5, 2009 at 12:32 am
Lowell (6/3/2009)
ALZDBA (6/3/2009)
Attached you'll find a version I use for quick and dirty CPR-trace 😉
ALZDBA the version you posted has all the CrLf stripped out, making it difficult to test,...
June 4, 2009 at 12:28 am
Attached you'll find a version I use for quick and dirty CPR-trace 😉
June 3, 2009 at 5:33 am
I didn't kill the sqlserver service !
I dropped the event service (sqlserver object).
DROP SERVICE S_Logon_Events_Service
There was a huge backlog because I defined to few quereaders.
June 1, 2009 at 11:59 pm
Viewing 15 posts - 3,676 through 3,690 (of 7,504 total)