Viewing 15 posts - 46,051 through 46,065 (of 49,571 total)
SQL has to do meta-data lookups whether or not * is specified as it has to find the types and the column lengths.
The reasons to not use select * ...
July 1, 2008 at 12:10 am
You can use the sys.dm_exec_sessions and sys.dm_exec_requests to see what's currently running on the server.
You can use the server-side trace procedures (sp_trace_*) to inplement a trace. They're the same procs...
June 30, 2008 at 11:55 pm
From the looks of the stats you posted, you have a very well-running SQL system that is on hardware more powerful than it currently needs.
Are you having performance problems, or...
June 30, 2008 at 2:50 pm
Brad M. McGehee (6/30/2008)
Oftentimes, it is more important to hire someone with the right attitude than specific knowledge.
Indeed, and I have several times recommended a hire just based on...
June 30, 2008 at 2:38 pm
jsheldon (6/30/2008)
June 30, 2008 at 2:38 pm
Jeff Moden (6/30/2008)
Dang.... that's exactly what they did at the place I work... the worst part is... the DBA recommended it! 😉
Here too, except the previous database architect recommended it....
June 30, 2008 at 8:13 am
anjan.ashok (6/30/2008)
I think the issue is with the version the instance showiing error version is 9.0.1399 and other instance in which maintainance job ran fine version is 9.0.3054
I thought you...
June 30, 2008 at 8:07 am
It's possible that you are bottlenecked on IO (likely) or memory, and hence the CPU can't get to full utilisation. In gneral, you don't want to see your CPU more...
June 30, 2008 at 8:05 am
Do the instances that do work have SSIS installed on them?
I seem to recall that in 2005 RTM (which is what you're running) maint plans required SSIS.
You may want to...
June 30, 2008 at 7:57 am
Grant Fritchey (6/30/2008)
Needless to say, he couldn't answer the questions and wasn't brought in for the full interview.
Gee. I wonder why...
June 30, 2008 at 7:56 am
There's no file-processor affinity for any database other than TempDB.
The recomendation I've seen for user databases is that they should have a max number of data files = 0.25...
June 30, 2008 at 7:49 am
Grant Fritchey (6/30/2008)
We ask 10 questions. They're stupid simple. Yet people with "10 years advanced experience" don't know the difference between a clustered and non-clustered index.
Likewise. I had an...
June 30, 2008 at 7:42 am
Paritioning may help, without seeing more info on the table design and delete statement I can't be more specific than that.
The async model may very well help. Scheduling the deletes...
June 30, 2008 at 7:29 am
anjan.ashok (6/30/2008)
one more question if the data file is growing rapidly wat the solution its taking more space.alteast log files we can shrink right.
Find out why the database is growing....
June 30, 2008 at 7:29 am
anjan.ashok (6/30/2008)
I am shrinking database once in a week.
It is not recommended to shrink databases on a regular basis. If you insist on doing it, make sure that you rebuild...
June 30, 2008 at 7:18 am
Viewing 15 posts - 46,051 through 46,065 (of 49,571 total)