Viewing 15 posts - 61 through 75 (of 152 total)
I will recommend best practice not put your own temp table into master database, instead, create an AdminDB, put everything DBA uses into AdminDB. Include AdminDB in regular backup.
July 27, 2011 at 12:52 pm
michael bourgon (2/4/2010)
GilaMonster (5/30/2008)
You did notice that the post you replied to is over a year old?
And? I'm reading the post looking for advice. And responding a year...
July 27, 2011 at 10:09 am
You should always have a cluster index on a table when you can. You should always use row-versioning based isolation level - in SQL Server snapshot isolation. In Oracle, it...
July 23, 2011 at 8:35 am
I see two major issues with Cloud.
1) the speed - first depending where your claoud is and where your workers are, not all things are equal. Windows authentication at times...
June 13, 2011 at 10:24 am
Finding blocking is one thing, I have done a monitor in web .Net since 2005. See my Houston PASS 2008 presentation.
Resolving root cause of blocking is another topic, see my...
June 8, 2011 at 8:14 pm
Both ends have short-comings,
MBA - we have more VPs, Directors than IT workers?, who is going to do the real work? With US trade deficit thru the roof, are...
May 17, 2011 at 2:01 am
Instead of chasing up purge with a frequent large delete, partition table at design time is a good option. The criteria you use in delete (whereclause) can be used for...
March 25, 2011 at 8:04 am
suspicion of excessive paging due to a lack of enough memory.
Your initial question is "suspicion of excessive paging due to a lack of enough memory."
Just seeing your memory size...
March 19, 2011 at 5:16 am
FreeListStalls ? FreePages? MemoryGrantPending ?
Did you have a lot read-ahead reads?
They are perfmon counters. See perfmon explain button. FreeListStalls - as few possible. FreePages - above 10K MemoryGrantPending...
March 19, 2011 at 5:06 am
Craig Farrell (1/7/2011)
Jason,%DiskTime and Queues are no longer valid parameters if you're working against SAN systems. If you have independent RAIDs, that's different.
Craig, I have a different experience. Yes,...
March 19, 2011 at 4:46 am
Many authors (books) wrote about how to set up SQL Server agent and jobs. Many forgot to mention setting up the "clean up" part which is equally important. There is...
March 9, 2011 at 8:03 pm
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
I...
January 28, 2011 at 9:51 am
Hi, shifty1981,
Did you check FreeListStalls ? FreePages? MemoryGrantPending ?
Did you have a lot read-ahead reads?
You show us the %DiskTime is 7358%? If K is where your mdf files are (only...
January 7, 2011 at 3:03 pm
Hi, mirzafahad1409,
To parse sophisticated text data (with multiple rules), you should use high level language like C# (it is easy to write and debug), you could embed C# into SSIS....
January 7, 2011 at 2:41 pm
Viewing 15 posts - 61 through 75 (of 152 total)