|
|
-
|
|
Sometime we are using triggers to get old and new values or new values for the historical data to save in another table. So we can get inserted, updated and deleted data using triggers.
But one amazing feature "Output" clause. ...
|
|
-
|
|
In SQL Server 2005 or previous version , whenever I was working to write the script, query or stored procedures at that time if i forgot object names which was going to used in the script, then i was need to get the proper object name by system query or from the list of objects in management studi......
|
|
-
|
|
I hope you all have attended Microsoft TechEd 2011 at Ahmedabad on 11th June 2011 and very interesting topics about SQL Server, ASP.NET, Windows Phones, Windows Azure and HTML 5 were there. I haven't missed anything from them and topics are very interested and enjoyable at all. Haven't you missed? ......
|
|
-
|
|
I notified so many times by the Object explorer when i goes to check the SQL Server Agent jobs. The notification is “Agent XPs disabled”.
Then i need to run the following queries to enable SQL Server Agent XPs,
EXEC SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE
G......
|
|
-
|
|
SQL Server Denali introduced one more feature which can easy and reduce our t-sql coding. This feature is "Code Snippets".
It is allows to insert code template in the query editor.
Here is some demonstration of this query editor new feature.
When you clink on Insert Snippets or Ct......
|
|
-
|
|
Ola Hallengren is a DBA in SQL Server and achieved MCITP Database Administrator and MCITP Database Developer certifications.
In the new version optimized performance in IndexOptimize for databases with large number of indexes or sql servers with large number of databases. The time for rebuildin......
|
|
-
|
|
With earlier version before 2008 of the SQL server, When we need to required hierarchical data at that time we were using the loop to get the data of parent - child hierarchy. And it was make code lengthy , very complex and costly as well.
What should be other feature and alternative for above?......
|
|
-
|
|
I have wrote for the best feature of SQL Server 2011 in my earlier post here, http://beyondrelational.com/blogs/paresh/archive/2011/05/20/tsql-enhancement-in-sql-server-denali-stored-procedure-execution-with-result-sets.aspx.
There i have given the demonstration of the usage of Resultset with exe......
|
|
-
|
|
It will a lengthy and complex coding if we need to perform insert, update and delete statement individually. Instead of write separate statements for the insert, update and delete operation, we have one more option which can be very helpful in t......
|
|
-
|
|
<div dir="ltr" style="text-align: left;" trbidi="on">
CTE (Common Table Expression) is best feature to get the hierarchy of the data and hierarchical depth. Using CTE we can also get the data easily by level wise with parent and child relation.
<br /><br />
Recently when i working with stored p......
|
|