Hi Firends,

This may be an old post but my doubt is vaild.

I have done a cumulative update for 2005 SP3 on a cluster.

The patching got failed due to some reason....

If I understand the requirement correctly, please take a look at the below steps that may help you:

1. Use the post snapshot script option to delete any unwanted object from...

Narrowing down the problem. I beleive the time taken is not related to the caching problem.

When a request is sent from ssrs report page, the analysis service starts an MDX...

Thanks

These are internal procedures which are called during the report creation.

These sometimes work faster. Sometimes slow. So its not related to SPs.

Let mee correct my previous message.

Its no the switch from data set.

Before generating the report, under the hood, the server executes serveral internal SPs.

After the execution of GetCompiledDefinition SP, it...

Thanks for the reply.

But my query is for the courses on networking, SAN, AD, etc (other than SQL). Will it benefit me in the long run in my DBA field.

Cheers

All OK now.

I was using textbox instead of table or matrix in the report layout.

Corrected now and its giving me multiple rows in the result.

Thanks

Nice article. Thanks for this.

I believe the failure of SQL Server 2008 RTM (Kerberos issue) pops up when we install SQL server 2008 on Windows 2008. I believe it works...

Hi,

In TSQL, the first and the last single quote marks the starting and ending of the string respectively. And every 2 single quotes, within the aforesaid quotes, represent one quote.

May be he intended for sp_help 'table_name', to get the entire table details, rather than sp_helpdb.

Cheers

Hi,

Answer 1:

Yes you can create replication even with 1 server.

This server will act as its own distributor.

You can subscribe for the publication, which is created in this server itself, to...

Hi John,

While CHECKDB process is running, SQL Server keeps the information about the scanned portion of DB. This is to compare the information at one point with another point. SQL...

Hi,

You can query from information schema view too, which provides the sql server metadata.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE column_name =''

This view provides both column name and tables names.

Thanks

Go to:

Control Panel>Add or remove programs>Add/Remove Windows components>Select IIS > point to "c:\windows\I386 folder" for the installation from the disk or image.

Cheers

There are huge lot of replication involved in huge lot of databases, which I'm planning to move.

So I think if I can get rid the replication rebuild, I can reduce...