How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
478 reads
Blog Posts
June Meeting - Data Architecture VC
June Meeting - Data Architecture VC
Data Architecture VC presents Karen López:
Subject:You've Just Inherited a Data Model: Now What?Start Time:Thursday, June 16,...
2011-06-10
696 reads
Microsoft TechDays 2011 in Kosova, Prishtina
It's late but I need to say some words about our local tech event, it is the only one that...
2011-06-10
1,996 reads
Planes Trains and Automobiles
I was going to write a short post showing some useful queries that can help you manage your vCentre environment,...
2011-06-10
487 reads
Re-blog – June 3-June 9
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-10
552 reads
Slides & samples from my DevConnections sessions
As announced in both of my SQL Server sessions at DevConnections in Karlsruhe/Germany
you can find here the slides & samples for...
2011-06-10
901 reads
SQL Dream Cars
A mini debate on Twitter the other day got me thinking about cars. People that know me know I like...
2011-06-10
1,520 reads
SSIS Webinar Recording Is Up
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I...
2011-06-10
687 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on....
2011-06-10
667 reads
Statistics IO parser in Ruby & Python
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on. I work through the obvious missing indexes and improper...
2011-06-10
9 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers