|
|
-
13
Liked
| 10
Learned
| 9
Comments
|
|
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** dialo...
|
|
-
|
|
Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for th...
|
|
-
|
|
I just learn from [Nakul''s Blog][1] That sp_dboption store procedure is “discontinued” SQl Server 2012
Replacement is the ALTER DATABASE statement, for existing sp_dboption
ALTER DATABASE TestDB SET READ_ONLY
Thank You
[1]: http://beyondr...
|
|
-
10
Liked
| 8
Learned
| 11
Comments
|
|
T-SQL's ISNUMERIC() function has a problem. It can falsely interpret non-numeric letters and symbols (such as D, E, and £), and even tabs (CHAR(9)) as numeric.
...
|
|
-
|
|
Few hours before I was checking the special features, fixes, and builds of MS SQL Server. I got a great blog...So interesting....This contains unofficial build chart lists all of the known KB articles, hotfixes and other builds of MS SQL Server 2012, 20...
|
|
|
|
-
13
Liked
| 12
Learned
| 1
Comments
|
|
sysname is a special datatype and by default it does not allow NULL, you need to explicitly add NULL in table definition to allow null. sysname is defined as
nvarchar(128) not null
Below code will give error
declare @t1 table ( c1 int, c2 sy...
|
|
-
13
Liked
| 12
Learned
| 1
Comments
|
|
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
|
-
14
Liked
| 16
Learned
| 3
Comments
|
|
All of us like Keyboard Shortcuts and use it frequently but memorizing them might be painful and we get to remember them after we use it over a period of time. I just found a very easy way to learn and remember the Keyboard Shortcuts in SQL Server Manag...
|
|
-
|
|
Fast parse supports the following string formats for date, YYYYMMDD and YYYY-MM-DD
Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day, for the extended format, the date parts are separated by a hyphen (-), also it's...
|
|