Recently we had a problem for adding users in Analysis service security option
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah
Problem in adding user in security page in Analysis Service
Recently we had a problem for adding users in Analysis service security option
Row count int sys.dm_exec_query_stats
SQL 2012 has added 4 new columns
total_rows,
last_rows,
min_rows,
max_rows in sys.dm_exec_query_stats DMV
This will help us to find the queries which are returning large number of results and we can optimized them
DMV to get SQL Server Registry information
SQL Server 2012 has new DMV sys.dm_server_srvices
This provides details in registry related to SQL server
This provides some interesting information like
SQL Server Version/Startup Parameters/Ports/Service startup options
This provides details in registry related to SQL server
This provides some interesting information like
SQL Server Version/Startup Parameters/Ports/Service startup options
Easy way to get status of SQL Server Services in SQL 2012
SQL 2012 has some new DMVs.
One of them is sys.dm_server_services
It gives us details about the SQL Server services (SQL Serve,SQL Server Agent, Full Text)
One of them is sys.dm_server_services
It gives us details about the SQL Server services (SQL Serve,SQL Server Agent, Full Text)
How to avoid MSDTC in linked query
As we all are aware of linked servers and how to use it
We can use it to query remote server as well as copy data from one server to other server
Till now if we want to execute procedure on remote server and insert data on to local server using linked server we need MSDTC enabled on the server
We can use it to query remote server as well as copy data from one server to other server
Till now if we want to execute procedure on remote server and insert data on to local server using linked server we need MSDTC enabled on the server
Subscribe to:
Posts (Atom)
Popular Posts
-
sp_addlinkedsrvlogin To modify or add new login for linked server
-
Recently we had hardware and performance issues on SQL Server,with our client , so while monitoring the system we also looked at error ... -
Recently I got a problem where Builtin\Administrators Account was deleted . How can we recreate it? Here is a solution for this Run th... -
As we all are aware with the variables in SSIS, which is used for holding custom values and assign to various properties of objects at run...
-
Recently I got a mail for following problem While the client tries to open registered server window in Mbanagement Studio he gets follow... -
Various way to calculate running total from All period to currentmember As MDX is a very vast and dynamic language we can write same quer...
-
Many time we need to do runing sum of value. In SQL 2oo5 we can do it with use of CTE -
sp_purge_jobhistory We can use this procedure to delete old history for jobs.
-
Index are very important part for any database. We need to regularly monitor index and maintain index for better performance of the system... -
For every Developer and DBA index maintenance is very important task. Since the changing ...