I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance?
Steve Jones likes the cloud, but doesn't necessarily trust it. After a recent Hotmail outage, he outlines a potential issue that he sees with cloud computing.
Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a value to a column. Just occasionally, though, you'll find that data gets truncated, queries run slowly, or comparisons just seem plain wrong. Robert Sheldon explains why you sometimes need to be very careful if you mix data types when manipulating values.
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
The 14th annual DevWeek conference takes place from 14-18 March 2011, at the Barbican Centre in central London, and once again incorporates two dedicated tracks on SQL Server, alongside seven concurrent tracks aimed at software developers.
Today Steve Jones talks about NOSQL and why it might be important for SQL Server DBAs to understand more about it and be able to talk about when it is appropriate to use.
It is always more efficient to maintain referential integrity by using constraints rather than triggers. Sometimes it isn't obvious how to do this. Until a recent idea by Alex Kuznetsov, the history table presented problems for checking data that were difficult to solve with constraints. Joe Celko explains.
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...
Given that disk storage has come down substantially in price over recent years, will RAID 5 continue to be relevant as a storage configuration for databases?
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
WhatsApp:083179431313 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
WhatsApp:083179431313 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur 60225
WhatsApp:0817866887 Jl. Kalimantan No.14, Gubeng, Kec. Gubeng, Surabaya, Jawa Timur 60281
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers