|
|
-
Nirav Liked 12 Months ago through Blogs
The script helps to identify the top 10 queries that use the most I/O as ordered by Total IO, taking more time to execute (means most expensive) across all databases on the server....
|
-
Nirav refreshed 12 Months ago through Blogs
The script helps to identify the top 10 queries that use the most I/O as ordered by Total IO, taking more time to execute (means most expensive) across all databases on the server....
|
|
|
-
Nirav Liked 12 Months ago through Blogs
Changing database options to make it read-only, or taking a database offline? If you are using sp_dboption, your code will not work with SQL Server 2012. Use ALTER DATABASE...SET statement instead....
|
|
|
|
|
-
Nirav Liked 12 Months ago through Just Learned
There is five way make Ajax calls with Jquery
load(): Load a piece of html into a container DOM.
$.getJSON(): Load a JSON with GET method.
$.getScript(): Load a JavaScript.
$.get(): Use this if you want...
|
-
Nirav Learned 12 Months ago through Just Learned
There is five way make Ajax calls with Jquery
load(): Load a piece of html into a container DOM.
$.getJSON(): Load a JSON with GET method.
$.getScript(): Load a JavaScript.
$.get(): Use this if you want...
|
-
Nirav liked 12 Months ago through Interview Questions
If a table has no clustered index defined on it, What it will be called?...
|
-
Nirav Liked 12 Months ago through Just Learned
There is five way make Ajax calls with Jquery
load(): Load a piece of html into a container DOM.
$.getJSON(): Load a JSON with GET method.
$.getScript(): Load a JavaScript.
$.get(): Use this if you want...
|