Exception handling in SQL Server
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...
2014-08-19 (first published: 2014-08-11)
10,180 reads
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...
2014-08-19 (first published: 2014-08-11)
10,180 reads
Suppose we need to find out the name of all the months in a given year (Year will be given...
2014-04-08
499 reads
Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?
Options:-
a) 1
b) 2
c) More...
2014-04-08
586 reads
Holi is the time to unwind de-stress and bond with sweets,Thandai and colours.Come let’s rejuvenate by immersing ourselves in the...
2014-03-16
388 reads
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record...
2014-01-11
777 reads
Question :- In which database temporary tables are created in SQL Server?
1) User database (where temporary table are defined)
2) Master...
2014-01-11
1,676 reads
Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...
2014-01-10
1,295 reads
Question:-
Which table is called Heap table in SQL Server.
1) Table without any indexes
2) Table without any clustered index (Correct...
2014-01-06
617 reads
Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...
2014-01-02
535 reads
Question :-
How many non clustered indexes are possible in a table in SQL Server 2008R2
1) 1
2) 249
3) 999 (Correct answer)
4)...
2014-01-01
1,090 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers