|
|
-
|
|
Before a some weeks ago i have posted for some enhancement like Zooming with the query analyzers and also with outputs as well. Here i would like to show the same but some another things also. In this enhancement SQL Server Denali introduces some of changed in query editors. List of changes: 1. Cha......
|
|
-
|
|
0 )
DROP TABLE CTEMaxLevelTab
GO
CREATE TABLE ......
|
|
-
|
|
0 )
DROP TABLE HierarchyTab
GO
CREATE TABLE HierarchyTab
(
NodeId INT IDENTITY(1, 1)
,NodeDepth VARCHAR(100) NOT NULL
,NodePath HIERARCHYID NOT NULL
,Node......
|
|
-
|
|
I have used Zoom feature with Windows which is inbuilt feature of windows itself or using some external tools but never with SQL Server.
SQL Server Denali arrived with one more feature and that's Zoom/Magnify. I found it somewhat playing with analyzer.
Let's look for the below image for this ......
|
|
-
|
|
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......
|
|