Queue, VideoQuest Software has just published the first of a few videos which I recorded with them. You can download or view the video from here. I've...
0 Comments
RSS Feed
Email a friend
In Person Events, Query tuning, Resource GovernorThe nice folks at the Inland Empire .NET User Group have invited me to come and speak to them. This is a great speaking opportunity for me as they are about 20 minutes from my house. I won't be speaking there until...
0 Comments
RSS Feed
Email a friend
Cache, Execution Plan, Query tuning, SQL Server 2005, sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, sys.dm_exec_query_plan, sys.dm_exec_requestsAs we all know SQL Server, will for good or bad, cache execution plans. Up until now it's been very tough to see the cached execution plans. You pretty much had to grab the query or procedure (with the parameters) and run it with Query Analyzer and have it return the execution plan. The only...
0 Comments
RSS Feed
Email a friend
SQL, T/SQL, xp_fixeddrivesI've seen some very creative ways to see how much free disk space SQL Servers have. Most make use of xp_cmdshell which some very complex dos commands or vbscripts. However there is a much easier way. Microsoft has included the system extended stored procedure xp_fixeddrives. It returns the...
0 Comments
RSS Feed
Email a friend
ERRORLOG, sp_who3, SQLThat "s" is new in SQL Server 2005. It means that the SPID is a system process. For example my database is having a problem with tempdb running out of space for no reason. When I look in the log I see that SPID 118s is the offending SPID. When I watch SPID 118 using
0 Comments
RSS Feed
Email a friend
DELETE statement, SQLWhen you have data in your table that you need to remove the DELETE statement is the way to do that. Using the DELETE statement without any WHERE clause will remove all the data from your table. The WHERE clause works the same way as the WHERE clause for SELECT and UPDATE...
0 Comments
RSS Feed
Email a friend
Article, Service Broker, SQL Server 2005, SQL Server 2008I’ve just published a new tip on SearchSQLServer.com called Configure SQL...
1 Comment
RSS Feed
Email a friend
Compliance, DataManagement, Encryption, SQL Server 2008While I think that the one click database encryption that Microsoft has built into SQL Server 2008 is a good idea, but I'm not sure how useful it actually is. It's touted as giving you data encryption of the entire database without any code change. What this actually means is that if someone...
2 Comments
RSS Feed
Email a friend
In Person Events, Service BrokerThe NJ SQL Server User Group has been kind enough to invite me to come speak to them about SQL Server Service Broker. I'll be speaking up there on August, 19,...
1 Comment
RSS Feed
Email a friend
Back To Basics, sp_change_users_login, SQLThe sp_change_users_login procedure has a specific purpose. It's used to identify and correct users within a database which do not have a corresponding logins. You can specify the value of Report for the @Action input parameter to see any users which do not have a corresponding login. This...
0 Comments
RSS Feed
Email a friend
