-
Recent Posts
Recent Comments
- Stefan on Aliases
- jonmcrawford on Aliases
Archives
Categories
January 2021 M T W T F S S « Sep 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Meta
Tags
Activity Monitor Administration aliases blog Community Data Database Data Warehouse Design Dev Edition error File System Task Help Index Install Intellisense Intro Knowledge Links Mail Naming Conventions Notification Oracle Resources reusability Service Pack shared access speed sp_ SQL Server SSIS Strange Behavior style Syntax testing Text Message tools Try...Catch variables Virtual Machines Visual Studio Web Sites WikiBlogroll
Tag Archives: testing
Clarity in Code
Commenting code is always a good idea and there are more ways than one to comment your code. When running a long series of SQL queries it can be useful to know what has run. If you have conditional statements … Continue reading
Lecture
I went to a SQL Server lecture tonight on Virtual Machines and SQL Server by Brent Ozar. It wasn’t what I expected. The lecture was great, as have been all the ones in this lecture series, but the advice was … Continue reading
Posted in 2008, SQL Server
Tagged Resources, SQL Server, testing, tools, Virtual Machines
Leave a comment
How much data is there?
We’re all familiar with trying to figure out just how much data is in our database. To get approximately how much memory the whole database takes up you can open SQL Server Management Studio, right-click on the database name you’re … Continue reading
Set Statistics
Any time you’re developing queries in SQL Server, whether they’re single use or intended for inclusion in a stored procedure that’ll be run frequently, you want to know how well your query is running. If it is intended for production, … Continue reading