Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe case of 'Cache Bloat' due to ad-hoc queries, but you can't fix the code itself. What should you do? Specify forced parameterization? Perhaps a better idea would be to use guide plans.
SQL South West user group are running their second SQL Saturday on March 21st and 22nd and have another spectacular schedule of technical content from SQL Server professionals from the UK, Europe and USA including SQL Server MVPs and Microsoft staff. All the session details and how to register for the full-day pre-con sessions or the free-to-attend Saturday:
Louis Davidson on the small dreams that DBAs can nurture, each day, to elevate the drudgery of a seemingly banal task into a celebration of purpose.
Most of us are working to prevent downtime in our systems. However Netflix thinks a little forced downtime is good for the software developers and infrastructure people.
Follow along as this starter article on the SQL TABLE Type walks you through the various ways it can be used in T-SQL.
Occasionally I come across UPDATE and DELETE statements where the target SQL Server table is referenced with the NOLOCK hint. Does this hint help or hurt performance in this case?
SQL Saturday is coming to Exeter on March 22, 2014. Join Red Gate's David Atkinson and the rest of the speakers at this free day of SQL Server training and networking, organized by SQL South West.
As a break from work, this week Steve Jones wants to know what you wish for. Are there comic book, science fiction, or technological thrillers you'd like to see made into movies?
Come see Grant Fritchey and Steve Jones (from Red Gate Software) and many more SQL Server experts while you enjoy spring in Orlando, FL at SQL Intersection.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCU BLOK A CIPETE HUB Tlpn.0821•3111•185 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5,...
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
Jl. Daan Mogot No.48 A, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers