Hi,
ver 2005
1.) What does it mean when it shows a job executed successfully at such and such time, but there is no history under "view history" ?
2.) Is there a reason that an "EXEC (mySQLStmt)" would not run from a stored procedure that is called from a job?
That is, if I run the "EXEC...
Dude, you are making the right choice... personally and karmically... you can do some other things in the meantime, and it ain't so bad -
1.) educate yourself in your spare time and be grateful for the opportunity to do so in your much NICER environment
2.) find another job with the...
Hi,
I just wanted to get a "consensus" about this issue.
Our company recently moved its datacenter out of state. We are now using SAN technology for all of our data files and backups... that is, everything now resides on the SAN disk array - files and backups.
To date, we have no mechanism in...
wait, i was confused... you are right...
i think the solution here is to convert some of these indexes to clustered indexes... since they are UNIQUE, non null anyways... it will be easier than the 3 options you mentioned
thanks
I find this statement interesting because every week the log indicates the the DBCC DBREINDEX took place on non-clustered indexes. And running DBCC SHOWCONTIG on the index in question, it shows:
- Pages Scanned................................: 102
- Extents...
found the culprit - the table is truncated on a weekly basis, then the fields re-populated
i guess that would explain the fragmentation? not sure how, though
MicheleWeaver,
first question - why does the error log also indicate SQL Server starting up?
second question - are you currently running 2005 on a 64 bit server?
if so, please be aware that there is a serious memory bug in 2005 on 64 bit servers
this may have nothing to do with your...
Hi,
I am examining the weekly index defrag report... I run DBCC REINDEX on a weekly basis on indexes that are fragmented.
This is weird. One of the indexes that was reindexed was an index on a numeric ID field - it's a nonclustered, unique, primary key index - don't ask me why this is a...
Hi,
I have a weekly job that examines the index fragmentation of all tables in a given database.
If the index fragmentation reaches a certain threshhold, then it runs DBCC DBREINDEX against the table, with a fillfactor of 75 (the decision to use 75 was somewhat arbitrary on my part).
However...
dear aarenot,
your read on the situation is totally off - frankly i could care less about a promotion here (i am already in the highest position I could ask for in my dept, as a DBA)- nor am i interested in status or title, i just want an intelligent, reasonable manager, and i just want to be...
select *
from
mytable
where
datepart(month, mydate) > 1
and
datepart(month, mydate) < 3
and
datepart (year, mydate) = 2006
-- this would return all dates with a month of February, or month = 2, in the year of 2006
-- see datepart in BOL
Thanks, all... really there is no solution here, and that's ok, I've decided, as it is time to move on!
Boss really is #3 on my list... #1 is lack of meaningful work assignments, and #2 is the fact that I can never make what I'm worth here
So even if #3 disappeared, I'd still be moving on to...
Hi,
Just want to get a reality check here. Prior to our company getting bought out, I had a pretty decent manager. Despite a few annoying idiosyncracies (like talking too much!), he was bright and energetic, and actually very helpful at times. I also had a pretty good relationship to his boss...
Thanks to everyone for their advice. SQLSister, thanks for the "data analyst" tip - sounds like that could be right up my alley... I actually had no idea what this was, and that I would be qualified for this type of work. Good to know. And there seem to be lots of jobs!
No, we're not going to any advanced stuff for now. It was more just an informational question, mostly for myself, because I seriously doubt we would ever use this here.
:-)
Hi,
Thanks for the posts. George, we have implemented your solution exactly. I guess my question is, what would be the next step, so to speak, using SQL Server solutions, such as OLAP and Analysis Services? That is, when do you know when to use these tools?
Thanks
Hi,
I have been at my present company for about a year and half. Before this job, I had been out of the IT loop for about 4 years due to living on a beautiful tropical island with no IT jobs :-)
That said, I was eager to return to IT, and a real paycheck. My previous career had been as an...
my favorite job was a temporary summer cook position but that was a different era, ha
so, at this point, i glean that knowing vb or c# is a good thing, along with dts, ssis, and reporting services
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.