Recently I got a query on how to use like clause. As we all know we can use to find word with pattern matching.
Here we will look a sample for it.
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
Like- SQL Server
Memory properties in Analysis Service
Preallocate
It will allocated specified amount of memory to analysis service.By specifying preallocate Analysis Service uses large memory pages and we can not swap this to page file. It can give better performance to Analysis Service.
It will allocated specified amount of memory to analysis service.By specifying preallocate Analysis Service uses large memory pages and we can not swap this to page file. It can give better performance to Analysis Service.
Except command -SQL Server 2005
Except command can be used when we want rows from table1 which are not in table2.
This command is supported in SQL 2005 and later versions.
Let see an example for this
This command is supported in SQL 2005 and later versions.
Let see an example for this
Interesect Command(SQL Server 2005)
One of new feature of SQL Server 2005 is except and intersect commands.
Lets look how it can be useful.
Lets look how it can be useful.
How to get log file size
Recently one guy asked me how to get logfile size and free space in the log file.
We can get this information from dbcc sqlperf command.
We can get this information from dbcc sqlperf command.
Cahced Plans - Using System Tables
SQL Server stores query plan in cache for each query run on the server in sys.dm_exec_cached_plans system table. We can get information of query text, query plan , memory used, and count of query execution.
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.
-
For every Developer and DBA index maintenance is very important task. Since the changing ...
-
Index are very important part for any database. We need to regularly monitor index and maintain index for better performance of the system...