|
|
-
Khyati Patel Liked 10 Months ago through Blogs
If INT data type reaches its upper limit we can try to change the data type to BIGINT. But how do you know when BIGINT would also start overflowing?...
|
|
|
-
Khyati Patel Liked 10 Months ago through Tutorials
In this chapter, we learn about the anatomy of a trace template, which gives body to the trace by defining the events and data columns captured in the trace. We also learn about customizing, importing and exporting traces....
|
-
Khyati Patel Liked 10 Months ago through Puzzles
This challenge is to generate a game schedule based on the teams given in a table.
The key point is each team has to play with another team in each round of the games.
|
-
Khyati Patel liked 10 Months ago through Just Blogged
<div>SQL Server 2012 (Denali) discontinued support for system stored procedure "sp_dboption". The suggested alternative is the ALTER DATABASE command. This post tries to examine each of the options supported with "sp_dboption" and finds out the equiv...
|
-
Khyati Patel Liked 10 Months ago through Just Learned
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|
-
Khyati Patel Learned 10 Months ago through Just Learned
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|
-
Khyati Patel Liked 10 Months ago through Just Learned
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|
-
Khyati Patel Learned 10 Months ago through Just Learned
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|
-
Khyati Patel Liked 10 Months ago through Blogs
Use a Windows process Id (PID) and not the SQL Server SPID to monitor the SQL Server activity generated by an application process. Use the SQL Server DMV - sys.dm_exec_sessions and the SQL Server Profiler to achieve this goal - very useful when working ...
|