Viewing 15 posts - 3,676 through 3,690 (of 7,503 total)
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
I played a bit with SSB .... monitoring is the big issue.
I use SSB to track some sqlserver events. (logins, failed logins)
I must state that in a single case of...
June 1, 2009 at 9:55 am
Viewing 15 posts - 3,676 through 3,690 (of 7,503 total)