Viewing 15 posts - 196 through 210 (of 447 total)
Most amazing for me is looking at the results out of 953 attempts. If some one doesnot recognize ResourseDB as system database is Ok. May be they don't...
May 17, 2009 at 8:51 pm
Also you can try this.
Try to run the DBCC Checkdb with maxdop 1 so that it doesnot go for parallelism.
And enable the following trace flags to capture error dumps of...
May 14, 2009 at 2:58 pm
Even I got this error couple of weeks back on a server and when contacted MS we are asked to update a patch for memory usage by 2005 server. ...
May 14, 2009 at 2:54 pm
Never worked with SQLSentry but had used Quest Spotlight in couple of projects and its pretty good. Only bad is that it won't store any historical data. Or...
May 14, 2009 at 2:43 pm
SELECT oracle.*,SQL.*
FROM OrclDB..MARY.SALES as oracle inner join database.dbo.sales SQL
inner join Oracle.ColumnName= SQL.columnName
No. Above example doesn't work. Option 1 won't work for me as Oracle.Table1 had 39...
May 14, 2009 at 2:40 pm
I know how to extract data from Oracle using MSDAORA or OPENQUERY but never made any joins between both data set.
And really don't know how to do that.
May 14, 2009 at 1:09 pm
Famson, thanks for the article. But, I hate using XML for configuration when you can store same in a configuration table.
May 14, 2009 at 8:37 am
SanjayAttray (5/13/2009)
May 13, 2009 at 9:18 am
Very well written step by step article. I for some reason always like articles / SOP with screen shots. They are easy to understand and for a good...
May 13, 2009 at 9:16 am
It would get created. Wouldn't we see most of the times, when database is created by an application had .dat as file extension? I still didn't figured why...
May 11, 2009 at 2:08 pm
Nice article. Good feature too. But would like to know how it would work with 1000's of tables on production where updates, inserts and deletes are in high...
May 11, 2009 at 2:01 pm
Thanks Bill. Excellent list. Will be very handy when upgrading to 2008 version.
May 8, 2009 at 2:16 pm
Navi's (5/1/2009)
DECLARE @query AS VARCHAR(20)
DECLARE @variable AS VARCHAR(5)
SELECT @variable = 'TEST' --> Command(s) completed successfully.
...
May 1, 2009 at 7:49 am
Good review of sysprocess table. Every DBA should know about this table. Though I know a couple of ones who are used to using sp_who2 but does have...
May 1, 2009 at 7:44 am
I always likes question which make me do some research before answering.
This one is an easy question.
April 30, 2009 at 11:49 am
Viewing 15 posts - 196 through 210 (of 447 total)