|
|
|
|
-
Nirav Liked 12 Months ago through Just Learned
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...
|
-
Nirav Learned 12 Months ago through Just Learned
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...
|
-
Nirav Liked 12 Months ago through Just Learned
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...
|
-
Nirav Learned 12 Months ago through Just Learned
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...
|
-
Nirav liked 12 Months ago through Interview Questions
When you create a stored procedure you provide an option with RECOMPILE
What does this do?...
|
-
Nirav Liked 12 Months ago through Blogs
Do you need to register a remote SQL Server instance on your server? Or do you need to change the name of a SQL server instance? sp_addserver will not work with SQL Server 2012 for remote servers anymore. Read today's post to know how to use: sp_addlink...
|
|
|
-
Nirav liked 12 Months ago through Interview Questions
In SQL Server, how do you find un-used stored procedures and un-used views?...
|
-
Nirav Liked 12 Months ago through Blogs
Today we explore a former table hint - FASTFIRSTROW - which tells the optimizer that it is important to have the first row returned as fast as possible, allowing the application to return results to the users faster. The table is now replaced by a query...
|