Madeira
 

תגיות פופולריות

Madeira מחשוב ענן SQL Azure הדרכה asaf aviv SQL Server Agent Security Maintenance Microsoft tempdb Data Types SQL Server Monitoring SQL Server 2012 הורדות אינדקסים Execution Plan Optimizer קריירה להיות DBA שיפור ביצועים Performance Tuning Programming T-SQL קהילת מומחי מחשוב Troubleshooting SQL Server 2008 R2 BI SQL Server Community כנסים ואירועים

כל ההורדות


PrintMax

This script creates the "PrintMax" stored procedure, which prints a text of any size. It's לסיפור המלא…


Rosh Hashana User Group Meeting Summary and Downloads

We hope you enjoyed the presentations. You can download the Scripts and PowerPoint presentations from here


Redundant Indexes

If you check your database, you might find quite a few redundant indexes. Dropping those indexes will improve performance and reduce a lot of maintenance overhead


Top 10 Features Every DBA Must Know

Attached are all the materials from the "Top 10 Features Every DBA Must Know" course that was presented at the SQL Explore conference


SQL Server for Developers

Attached are all the materials from the "SQL Server for Developers" course that was presented at the SQL Explore conference


SQL Server for Beginners

Attached are all the materials from the "SQL Server for Beginners" course that was presented at the SQL Explore conference


Copy Login

This script will create a new SQL Server login with the requested name and password, and it will copy all the relevant data from the old login


Thirty Things You didn't Know about SQL Server

בתחילת אוגוסט העביר גיא גלנצר את הקורס "30 דברים שלא ידעת על SQL Server" במסגרת כנס Expert Days 2010. בואו לראות את החומרים ולגלות כמה נתונים מפתיעים


Create Executer Role

Database fixed roles are predefined roles with specific permissions, that allow their members to take actual roles in the organization. What is missing is a “db_executer” role that has EXECUTE permissions on all the stored procedures and functions in the database. So here is a stored procedure that creates such a role and assigns to it all the relevant permissions.



Buffer Pool Distribution by Tables

כשהשרת סובל מבעיות זכרון, יכול להיות מאוד מועיל לראות כיצד הזכרון ב-Buffer Pool מתחלק בין הטבלאות השונות. הנה סקריפט שעושה את העבודה.


Job Executions at Point in Time

SQL Server Management Studio doesn’t provide ways to filter according to a specific point in time. You need to manually search for the relevant job executions. If you have a lot of jobs and a lot of job executions, this could be a cumbersome search. This batch does the work


Buffer Cache Hit Ratio Script

The buffer cache hit ratio can be monitored through Performance Monitor. Since all the SQL Server counters can be viewed through sys.dm_os_performance_counters, here is a simple batch that displays the buffer cache hit ratio on your instance.


Statement-Level Query Statistics Script

This script creates two function and a view that returns query statistcis based on sys.dm_exec_query_stats at the statement level.


Indexes List Script

This query returns the list of all indexes in the current database, including included columns.


תגובות אחרונות