Are your database servers not performing well? Have you discovered two or more virtual servers running on the same node? Shailesh Khanal shows you how to generate a status report for multiple database servers and services, schedule it to run automatically and send it out via email.
2009-12-01
2,555 reads
For SQL Server and Exchange Server, Windows Server Virtualization is going to be increasingly important as a way for the administrator to allocate hardware resources in the most efficient way, provide more robust services, and deploy services. Jaap Wesselius starts his new series on Hyper-V by explaining what Hyper-V is, how it relates to Windows Server 2008 and how it compares to ESX, Virtual Server and Virtual PC.
2009-07-01
2,890 reads
Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.
2009-06-23
2,604 reads
Virtualizing SQL Server has pros and cons. Learn the performance impacts of virtualization on SQL Server I/O, RAM and memory to decide if it is a fit for your SQL Server system.
2008-12-15
4,829 reads
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
I’m excited to announce the release of a new open-source project that fully automates...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers