|
|
-
Different ways to get the internal database version for SQL Server
|
-
Which are the options available to a DBA to tune a SQL Azure database?
|
-
Why it is important to maintain Temporary database?
|
|
|
-
Identifying Employee level in Employee hierarchical structures
|
-
Your task is design the high availability architecture that should comprise the above 3 features of SQL Server 2008 R2. Further the solution must comprise no downtime to the application having the explanation for each step you will need to follow in design, develop and implement the solution. In addition to that you must explain the failover and failback of the databases, including the recovery time for the application.
Also discuss the pros and cons about the solution you are proposing.
|
-
You're migrating an old system into SQL Server back-end. In one of the tables you're currently working on you had a description field. You ran a statement to find the average and maximum length of that column and found 500 and 3785 respectively...
|
-
When accessing SSIS Remotely, you might get an error RPC Server is unavailable what is the work around you would suggest in this case?
|
-
Many legacy systems from the 20th century stored dates as decimals due to limitations of the technology at the time. For example 08/03/2011 would be stored as a decimal with value 20110803. Modern reporting platforms that enable self-service reporting like [Izenda Reports][1] require dates to be stored in the proper format. Assuming there are a large number of fields with this structure but the name is always the same, what would be a simple way to convert the decimal to a proper date type?
|
-
Can a constraint help optimizer to get optimized plan and there by better performance? If Yes explain with a scenario
|
|