Viewing 15 posts - 4,186 through 4,200 (of 7,496 total)
Searching if this bug was know by MS, I stumbled onto:
http://support.microsoft.com/kb/951188
This kb does not 100% describe the symptoms I experienced, it states the hotfix was included in Cumulative Update 7.
The...
January 7, 2009 at 2:06 am
Lynn Pettis (1/6/2009)
ALZDBA (1/6/2009)
Lynn Pettis (1/6/2009)
This may be a dumb question, how do I get to the files in the exe file? I've never had to do that before.
I...
January 7, 2009 at 1:37 am
GilaMonster (1/7/2009)
ALZDBA (1/7/2009)
However there may be a TEMPORARY bypass by using the startup parameter that has been provided for the "views with order by nolonger work" problem.
With one caveat:
From the...
January 7, 2009 at 1:04 am
sqlcool (1/6/2009)
is it acceptable?
how to make it better performable?
if indexes cannot be dropped and essential for the system is there ay other...
January 7, 2009 at 12:49 am
Once again a UDF got you in troubles because of hidden joins !
You should really rework that to proper joins in you calling queries and get control over you queries.
However...
January 7, 2009 at 12:42 am
Like Gail said, you should first figure out if that is the cause of you cpu hog.
Use SQLserver profiler and Windows perfmon to figure out what's goin on !
You could...
January 7, 2009 at 12:29 am
Kinnari Thaker (1/6/2009)
I get following error when i try with query analyzer:
'It is not recognized resotre option'
what does...
January 7, 2009 at 12:23 am
Better would be to use the information schema views.
Keep in mind that sql2005 only show object definitions you are granted to view.
(view definition granted)
Is this what you're looking for ?
SELECT...
January 6, 2009 at 1:22 pm
Lynn Pettis (1/6/2009)
This may be a dumb question, how do I get to the files in the exe file? I've never had to do that before.
I don't know it...
January 6, 2009 at 12:56 pm
Ells (1/5/2009)
I have read Gails post and very informative it is. I will look at the other blog. I have a feeling that there are no trasaction log backups...
January 5, 2009 at 6:19 am
Paresh Randeria (1/5/2009)
If not than do we have any better alternatives?
I am working on Datawarehouse application where previous DAY...
January 5, 2009 at 4:27 am
Gail explained the basics very well at http://www.sqlservercentral.com/articles/64582/
btw you need to take log-backups to clean up the log files content !
If you don't, they will be growing on and...
January 5, 2009 at 4:17 am
Check out http://www.sqlservercentral.com/articles/Administration/2960/
it refers to http://support.microsoft.com/default.aspx/kb/954606
MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008
January 5, 2009 at 4:11 am
I've recently advised to create a number-bucket table for this kind of stuff.
Preparing a series of numbers for a key-identifier (i.e.customer in your case) and marking it 'free/taken'.
providing a sproc/function...
January 2, 2009 at 2:46 pm
- did you try starting the instance using:
net start mssql$sqlexpress
- did you find the info a the folder I pointed to in an earlier reply ?
January 2, 2009 at 10:19 am
Viewing 15 posts - 4,186 through 4,200 (of 7,496 total)