|
|
-
|
|
May be you already read my earlier post for the COLUMNSTORE index introduced by SQL Server Denali CTP3. I have also posted NEW THINGS which i have learned and what is new.
Now i am going to demonstrate something new about analytical functions comming in SQL Server Denali CTP3 version. So let lo......
|
|
-
|
|
Everyone know about the database backup restoration. This is one need for every developer or DBA. I want to demonstrate here as we have a database backup and how can we restore it with Management Studio. Because somebody don't the database backup restoration process with TSQL script. So here is ......
|
|
-
|
|
After downloading SQL Server Denali CTP3 i have posted some new features. You can visit my earlier post for the overview with list of all features. Today i have reviewed a new feature and it is COLUMNSTORE index which is introduced by SQL Server 2011 CTP3.
What is COLUMNSTORE index ?
It is sp......
|
|
-
|
|
You may already downloaded SQL Server Denali CTP1 and hope you practiced all the new features of CTP1. You can also read new features of CTP1.
I have downloaded SQL Server 2011 CTP3 and get started to review new features arrived with it. After completion of CTP1 review, you can download CTP3 here, ......
|
|
-
|
|
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......
|
|