if any body working in insurance company, please let me know what BI tools you guys are using.

thanks

Hi juancabrer, do you have SQL Server 2008 R2 SP2 CU8 in your environment?

fsaagent waittype is the top wait type. It's OLTP environment. MAXDOP is 1.

Nothing is changed in the application except CU8 installation. From last few weeks the CPU usage is <25%. But today, CPU usage is 40 % most of the time.

Thanks Lowell.

I'm looking for kind of complete SQL Server 2012 administration training in DVD's or online training. There are lots of sites but wanted to know popular ones.

Thanks

Thanks Jerry,

We have only one production ORACLE database with 6 schemas in it and having this makes database maintenance is very easy as application works great.

For example set up data...

I have looked at the code. It is this code that is setting the directory structure.

INSERT INTO @CurrentDirectories (ID, DirectoryPath, CreateCompleted, CleanupCompleted)

SELECT ROW_NUMBER() OVER (ORDER BY ID), DirectoryPath + CASE...

Thanks Lowell..that helped a lot.

DECLARE @intFlag INT

SET @intFlag = 1

WHILE (@intFlag <=5)

BEGIN

PRINT @intFlag

SET @intFlag = @intFlag + 1

CONTINUE;

IF @intFlag = 4 -- This will never executed

BREAK;

END

GO

The [Continue] statement in the below will work similarly...

Ola,

What is your referring to DatabaseNameFS in the following script?

SET @ErrorMessage = '';

WITH tmpDatabasesCTE

AS

(

SELECT name AS DatabaseName,

...

Thanks Ola.

I have changed it to SET @CurrentFilePath = @CurrentDirectoryPath

But still it's trying to create sub directories and failing

how you guys do you datafixes in SQL Server?

No. I just wanted to know which tool is the best one (sqlcmd or ssms) to log the script...

Inside the server, It's working when I open the Internet explorer Run As Administrator:-):-)

Out side the server, it just works fine...thanks

I changed the script to include master.sys.databases. But still, sometimes performs the Index defrag for all...