Q&A
- Where shall I locate the witness database?
- Why is insert over linked server so slow?
- Why does task take so long when I have an open VPN connection?
- How can I have a picture fit in a tablix cell in SSRS?
- How do I enforce uniqueness if a value exists?
- Why does MDX Queries fail after upgrading to SQL Server 2008 R2?
- Why don't my trace flag work?
- Why don't you allow automatic installation of updates?
- How ineffective can XML actually be?
- What is GhostCleanupTask?
- How do I truncate all tables?
- Why does my object show in wrong schema when I perform a database compare?
- How do I change SSRS to use metric measures instead of imperial?
- What does Event ID 833 from MSSQLSERVER mean?
- Why does it take a long time to show "User Mapping"?
- Why does it take a long time to "view database permissions" or show "database properties"; on my server?
- What are the characteristics of good transactions?
- What does the coalesce function do?
- How do I automate creation of a backup user?
- How do I find logins with administrative rights?
- How do I find objects using a linked server?
- Why should we use SQL-92 join syntax?
- Why do you only recommend named instances?
- Why does some strings start with N'?
- Why won't my log file shrink after backup?
- Can you logon using Windows authentication from a workgroup computer?
- Is the order of joins irrelevant?
- Why can't I add an included column to a clustered index?
- How do I solve SQL Server Error 5184?
- How do I compute the median value for each group?
- How can I remove duplicate tuples from a relation without any candidate keys?
