Viewing 15 posts - 1 through 15 (of 88 total)
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...
April 3, 2011 at 7:59 am
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...
February 23, 2011 at 2:05 am
Thanks
These are internal procedures which are called during the report creation.
These sometimes work faster. Sometimes slow. So its not related to SPs.
February 18, 2011 at 2:52 am
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...
February 16, 2011 at 10:45 am
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
February 13, 2011 at 10:21 am
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
February 6, 2011 at 4:19 am
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...
January 2, 2011 at 2:26 am
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.
January 1, 2011 at 1:31 pm
May be he intended for sp_help 'table_name', to get the entire table details, rather than sp_helpdb.
Cheers
January 1, 2011 at 12:58 pm
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...
January 1, 2011 at 12:52 pm
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...
December 20, 2010 at 4:18 pm
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
December 20, 2010 at 3:57 pm
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
December 2, 2010 at 9:32 pm
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...
November 18, 2010 at 8:59 am
Viewing 15 posts - 1 through 15 (of 88 total)