|
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
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.
...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
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 la...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
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 sho...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
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 d...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
<div trbidi="on" style="text-align: left;" dir="ltr">
In past, during development of the stored procedures, I have used XML or VARCHAR datatype with comma seperated data values as parameter of stored procedure. This was the option before SQL Serv...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
I hope you already read my previous post for the "Login failed for User" - Reason 1. And you have very idea on that how user was failed due to default database assigned to associated User. After default database changed User was success to login in SQ...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
I have just created papers on paper.li for the SQL Server updates and socialized it. It giving the daily headlines of the posts and technology news for the SQL Servers by categorized with various tags like Headlines, Technology , #JustLearned and all ...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
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 ch...
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
0 )
DROP TABLE CTEMaxLevelTab
GO
CREATE TABLE ......
|
-
Nirav Liked 1 Years ago through Blogs | 1 Point
0 )
DROP TABLE HierarchyTab
GO
CREATE TABLE HierarchyTab
(
NodeId INT IDENTITY(1, 1)
,NodeDepth VARCHAR(100) NOT NULL
,NodePath HIERARCHYID NOT NULL
,Node......
|