Our SQL Server Forum Support Team authored, collected and consolidated those common asked questions in SQL Server MSDN and TechNet forums into this ebook so as to provide an offline reading and learning experience for IT professionals and people who are interested in SQL Server. In this ebook, there are totally about 101 items covering database administration, SSAS, SSIS and SSRS which are good references for you to handle common SQL Server problems.
...
Part I Database Administration
1. Why did a T-SQL script fail to run a job when it could successfully run in SQL Server Management Studio ? 6
2. How can I degrade a SQL Server database from a higher version to a lower one? 8
3. How can I create a linked server to the Access or Excel data source from the 64-bit version of SQL Server 2005/2008? 9
4. Why is all of the memory allocated for SQL Server not shown in Windows Task Manager? 11
5. How do I configure SQL Server to use larger memory space over 2GB on a 32-bit server? 13
6. How do I rename my SQL Server instance? 15
7. How do I store data in multiple languages within one database? 16
8. How do I calculate the space a nullable column takes in SQL Server 2008? 17
9. Why can't I view the list of databases, tables, views and etc. in the SQL ServerManagement Studio Object Explorer? 18
10. Why can't I by pass the "Restart computer" rule when installing SQL Server 2008? 19
11. Can SQL Server Enterprise Edition be installed on client operating systems? 20
12. How do I troubleshoot SQL Server connectivity issues? 21
13. Why can’t I track data changes even though I already enabled the database audit on my database? 22
14. How do I use Powershell script to read the information of any database on a server? 23
15. Why can't I log on to SQL Server using Windows Authentication in SQL Server Management Studio? 24
16. What permission(s) do I need to execute a stored procedure (sp)? 25
17. How do I troubleshoot SQL Server 2008 installation issues? 27
18. How do I configure SQL Server to enable distributed transactions via Linked Server? 28
19. How do I find the correct "server" or "data source" value for an SQL Server instance in a connection string? 29
20. How do I configure Windows Firewall to allow remote connections using TCP/IP protocol for SQL Server? 30
21. Could SQL Server 2008 Express edition and SQL Server 2008 R2 Express edition be installed side by side with SQL Server 2005 Express? 32
22. How do I apply a service pack for an instance of SQL Server 2005 Express Edition or SQL Server 2008 Express Edition? 33
23. How do I resolve ‘SQL Server Setup cannot valid the service accounts’ error message during the setup? 34
24. Why do I get ‘Rule “Existing clustered or clustered-prepared instance” failed’ error while adding new features to an existing instance of SQL Server Failover Cluster? 35
Part II Analysis Services
25. How do I clear the warm cache of a cube? 38
26. How do I exclude data members or create non-aggregatable values in parent-child dimensions? 39
27. How do I specify a calculated member as the default member of an attribute? 41
28. How do I create AVG measure in my cube? 42
29. How do I implement dynamic security for the users? 43
Read more: Greg's Cool [Insert Clever Name] of the Day
Read more: SQL Server Community FAQs eBook download
Posts
0 comments:
Post a Comment