|
|
-
|
|
I've compiled a list of the questions that I get asked most frequently. If you have a question that I haven't answered or you need a more detailed answer, you can comment on the blog or contact me. Please read through to see if I've answered it already. FAQs were lasted updated on 13th August 201......
|
|
-
|
|
To send BCC and Copy in SQL Sp_send_dbmail, use this way to send email from a configured Database Mail server.
EXEC msdb.dbo.sp_send_dbmail
@recipients = N'JackVamvas@sqlserver-dba.com',
@copy_recipients = 'JackVamvas@sqlserver-dba.com’
@blind_copy_recipients = 'tuning@sqlserver-dba.com&r......
|
|
-
|
|
To manage db2start on all DB2 instances on a server, there is a workaround to use. This is not standard way of managing db2start, but I have found the method useful.
If you are using Clustering software such as Tivoli Storage Automation (TSA), then the TSA scripts manage the db2start process.
Cr......
|
|
-
|
|
This Performance Analysis Case Study looks at UPDATE statements on very large tables
and how to use Disable Index and Rebuild Index for performance gains.
A developer was executing an UPDATE statement on an ETL staging table. The table
is ~ 550 million rows. Th......
|
|
-
|
|
Often there is a requirement to enforce SQL Server Security Policies. This powershell script - in part 7 -
will take a list of sql server instances, iterate through every instance, generate a list of Logins and return TRUE or FALSE for the fixed server roles: SYSADMIN, SECURITY, SERVER ADMIN, SETU......
|
|
-
|
|
Use SET SHOWPLAN_XML instead of SET SHOWPLAN_TEXT or SET SHOWPLAN_ALL. Microsoft announced at the SQL Server 2008 release, SET SHOWPLAN_TEXT or SET SHOWPLAN_ALL are deprecated.
The advantage of using SET SHOWPLAN_XML ON is that the code is not executed. Executing the t-sql returns the exec......
|
|
-
|
|
Certain Dynamic Management Views(DMV) return a sql_handle column.
Examples of DMVs returning the sql_handle column are:
sys.dm_exec_query_stats
sys.dm_exec_requests
sql_handle is a varbinary(64). A varbinary is suitable for variable length binary data. The sql_handle is a token referencing a ......
|
|
-
|
|
From tomorrow, I’m posting a series of articles on Performance Tuning overview. The focus is not specific configurations or platform specific techniques. It’s a summary of general techniques, which DBAs can apply to most systems.
In most cases the DBA weighs up the cost versus benef......
|
|
-
|
|
This powershell script assists in applying a similar change on every SQL Server
Instance. Or a subset.
For example, adding a new generic logon account, or collecting regular information.
I’ve written plenty of powershell scripts – that are customised for a partic......
|
|
-
|
|
Key Points
Creating a common foundation between SQL Azure Cloud and Denali. Denali is SQL Server version 11 of the SQL Server Code.
Expanding capability for spatial data types - Geometry data type (Euclidean - flat-earth) and Georgraphy data type (ellipsoidal – round earth).
To interact ......
|
|