Office Hours: Ask Me Anything About Microsoft SQL Server
Ask your questions at https://pollgab.com/room/brento and I'll answer the most highly voted ones. The questions I answer in this video are:
00:00 Introductions
02:35 How can I tell if my SQL Server has too much memory?
05:20 Does normalization have a big performance impact?
08:08 What performance metrics should we show to the business?
11:17 Are SQL Server's index recommendations any good?
12:37 Thank you for all you do for the community.
13:24 Are GUIDs a good clustering key for high concurrency?
15:54 Should I stack multiple SQL instances on the same physical server?
17:41 Do foreign keys help with performance?
21:05 Is there a benefit to having an identity column?
22:25 Why is my query blocking itself?
25:29 Should I separate my database into multiple databases?
27:46 What's the best data type for primary keys?
28:13 Should I enable RCSI locally since I use Azure SQL DB for production?
29:32 Is my SQL Server slow because of my network?
32:40 How should we move documents out of the database?
33:30 Which query should I tune first?
35:50 Is SQL Server 2019's UTF8 support a game changer?
38:13 Which query filled up my TempDB?
40:35 Will there be a SQL Server 2021?
43:35 What's the best way to implement version control?
44:23 What performance change yields the best bang for the money?
45:49 Is 1,000 logical reads a big deal?
46:58 What security role lets people administer SQL Agent jobs?
48:35 How can I determine what permissions an application needs?
50:35 How should I configure quorum for my cluster?
Watch video Office Hours: Ask Me Anything About Microsoft SQL Server online without registration, duration hours minute second in high quality. This video was added by user Brent Ozar Unlimited 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,480 once and liked it 140 people.