|
All Blog Posts
-
|
I got a query from one of the blog reader. How to swap the values in a column? There is a column "availability" in a table and it's have 2 values "Yes" or "No". The user have wrongly entered the values. Instead of yes...
|
-
|
Writing in my blog after a very long time. Last month, I got a very nice opportunity to share my knowledge on SQL Server 2008 - Manageability features to chennai SQL experts. It was a unforgottable experience and I enjoyed the whole day with my fellow...
|
-
|
Considering am having a trace file in the location, "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLSERVER2008\MSSQL\DATA\audittrace20100707161605.trc" How to open the trace file? Is it possible to fetch it as a table. So that, we can play...
|
-
|
While creating audit and enabling it, am getting the below error. ------------------------------------------------------------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo...
|
-
|
Check my SQL Server 2008 session in Chennai on July 17th. It's a biggest SQL Server MVP Summit in chennai. I am taking a session on SQL Server 2008 - Manageability features. Hoping to meet you all (My dear Blog readers) URL - http://sql-articles.com...
|
-
|
Usually, we used to here the messages like problem with 1033 folder or similar kind of problem. What's this 1033 folder? It's nothing but "A specification for the SQL Server language installed in the machine" 1033 - In windows term language...
|
-
|
While trying to use windows application, I got a peculiar timout error. SqlCommand cmd = new SqlCommand("My_Report_Proc", conn); cmd.CommandType = CommandType.StoredProcedure; //dataGridView1.DataSource = cmd.ExecuteReader(); // bind the data...
|
-
|
Sometimes, we used to monitor the performance of our application. In that case, I have seen the application name is generic. For instance, If we use 2 dotnet application to access the database both were showing the application name as ".Net SQLClient...
|
-
|
I got a chance to create a report in SQL Server 2008 and deploy the same in IIS. Below is error recieved. " The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver...
|
-
|
Usually, we will face an issue with Database diagrams. Below is the error while trying to create new database diagrams. This issue is due to access. While upgrading your database or attaching or restoring a lower version of database into higher version...
|
-
|
To find recently executed queries, Select dmStats.last_execution_time as 'Last Executed Time',dmText.text as 'Executed Query' from sys.dm_exec_query_stats as dmStats Cross apply sys.dm_exec_sql_text(dmStats.sql_handle) as dmText Order...
|
-
|
DB_Name(DB_ID) will provide you the database name. The hierarchy is like system tables will have the initial values followed by user databases. select DB_NAME(1) --- returns Master database select DB_NAME(2)--- returns Tempdb database select DB_NAME(3...
|
-
|
Procedure to get the SQL Agent properties: CREATE PROCEDURE sp_get_sqlagent_properties AS BEGIN DECLARE @auto_start INT DECLARE @startup_account NVARCHAR ( 100 ) DECLARE @msx_server_name sysname -- Non-SQLDMO exposed properties DECLARE @sqlserver_restart...
|
-
|
sys.dm_os_wait_stats - This sysem related DMV will provide all the OS related information like, 1. Any I/O acitivity happening. 2. Context switching details 3. Pre-emptive switching. 4. Page / Extent related information. 5. Query waits 6. Memory usage...
|
-
|
DBCC Showcontig will give a detailed insight on the data pages(OS level) for the tables. This command will scan the table and provide the below details, - Pages Scanned......................... - Number of pages scanned (Denotes the number of pages occupied...
|
More Posts Next page »
|
|
|