|
|
-
|
|
I want to write here some general activity for everyone who are worked with SQL Server, even they are database developer or DBA. I know everyone know for the database backup and they are performing it as well. Below are the whole demonstration of to do full database backup. I hope you alread......
|
|
-
|
|
Task List or Ctrl+\,T. It will appear as following.We ca......
|
|
-
|
|
Problem:
One day when i was creating a new database, i was notified as "Could not obtain exclusive lock on database 'model'. Retry the operation later" and i could not able to sucees to created that database.
The error looks,
TITLE: Microsoft SQL Server Management Studio
Create failed ......
|
|
-
|
|
<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 Server 2008 arrived whenever we required to used it.
<br......
|
|
-
|
|
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 SQL Server instance.
If you have not read that......
|
|
-
|
|
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 other SQL Server daily publications.
It dail......
|
|
-
|
|
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 ......
|
|