|
|
-
|
|
In this post, we take a look at the Dynamic Management Vies, functions and Catalog Views related to AlwaysON! - the High Availability & Disaster Recovery [HADR] enhancements introduced in SQL Server 2012....
|
|
-
|
|
One of my friends asked me if it is possible to load multiple resultsets returned from a stored procedure into a temporary table for some analysis purpose. The answer is "It depends". If all the resultsets return same number of columns then it is possib...
|
|
-
|
|
When recovering from a database crash, an understanding of the backup timeline and restore sequence is essential. Full, differential and transaction log backups need to be restored in a specifc order. The system stored procedure sp_can_tlog_be_applied helps administrators in determining the restore sequence for transaction logs....
|
|
-
|
|
When I first started working on WCF three years ago, it was an entirely new paradigm for me. I had earlier worked on VB6, C# WinForms and ASP.NET to some extent. I had created some DLLs as well. But working with WCF was entirely a new thing. On top of i...
|
|
-
|
|
Enum, like class, creates a new data type. Hence, enum is at the same level as a class, struct or interface.
namespace AllAboutEnum
{
class Program
{
static void Main(string[] args)
{
Result r = Result.PartialSuccess;
...
|
|
-
|
|
Is it possible to create a VIEW based on other VIEWOptions:1. Yes2. No3. Non of the above4. OthersANSWER____________Condition: Select appropriate answers from the options and if non of the answer is suitable for the question or if you want to explain ...
|
|
-
|
|
You all know about the database file structure as whenever we created databases without specifying file location and filegroups , they will be created in default path and default filegroup. Here i have tried to created a new database without defining an...
|
|
-
|
|
Is it possible to use PIVOT keyword with out using aggregate functions.
Options:
1.Yes
2. No
3. Other
ANSWER:___________
Condition: Select appropriate answers from the options and if non of the answer is suitable for the question or if you want to expla...
|
|
-
|
|
Data Explorer is generating a lot of positive buzz within the community and everyone I speak to seems to be really excited about this. (If you are wondering what Data Explorer is, you might want to quickly catch up on my previous post - Introduction to ...
|
|
-
|
|
Bill is the sales director of a certain pharmaceutical company. He is in urgent need to prepare a certain product sales report to impress the clients in an important bidding event. This report requires presenting the monthly sales value, monthly growth, and year-over-year growth of these 3 products....
|
|