|
|
-
Chintak Chhapia Liked 5 Months ago through Blogs
Working with SQL Server logins and users is one of the most important and critical activities when moving databases from one SQL Server instance to another. The hash value for SQL Server logins created in SQL 7.0 or earlier are 16-bit values and are no ...
|
-
Chintak Chhapia Liked 5 Months ago through Blogs
Often the most obvious information can be the most confusing - What does the "Number of Users" value in the Database Properties window of the Object Expolrer in SSMS really stand for? This post answers the question....
|
|
|
-
Chintak Chhapia Liked 5 Months ago through Blogs
In this post, I walk you through how to restore broken file associations using the SQL Server Management Studio (SSMS) for SQL 2012....
|
-
Chintak Chhapia Commented 5 Months ago through Blogs
@Dubelewskyj: Glad that you find this helpful. In case you described, I presume you also want to return data from any table.
SSIS always needs exact datatype, so in any case you need to output in one datatype.As int can be converted to nvarchar, you...
|
-
Chintak Chhapia Posted 5 Months ago through Blogs
In earlier versions of SQL Server, if we want to use stored procedures in OLEDB source command which contains temporary tables we take some workarounds mentioned below
1. http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/65112/
2....
|
-
Chintak Chhapia Liked 5 Months ago through Blogs
During upgradation of a client database from SQL Server 2000 (Compatibility Level 80) to SQL Server 2005 (Compatibility Level 90), I have found that there are changes which need to apply for compatibility level 90, that are still not documented...
|
|
|
-
Chintak Chhapia Liked 6 Months ago through Blogs
Most import decision by Database Administrator is that a query on development server, where only hundred or thousand of rows exists, can also perform flawless according to given benchmarks when we will deploy same query on production server, where numbe...
|
-
Chintak Chhapia learned 6 Months ago through Blogs
Most import decision by Database Administrator is that a query on development server, where only hundred or thousand of rows exists, can also perform flawless according to given benchmarks when we will deploy same query on production server, where numbe...
|