Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Effect of space on SQL Queries

Home
Forums

Effect of space on SQL Queries

Chintan Dave

8yAsked Aug 20, 2018, 5:23 AM913

How availability of space on production sql server can affect performance of sql queries?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Pravat Kumar8y ago
Accepted answer
Hello Chintan,
SSMS query results cache to the C: drive by default. Go to Tool \ Options. See attached. Change this to another volume with more storage and you should be fine.
Please refer to the below link
https://dba.stackexchange.com/questions/21895/system-disk-run-out-of-space-when-running-heavy-sql-queries-on-sql-server-2012/21900#21900
+2
Hiten Pandya8y ago
Hi Chintan Dave,

Please refer the below link it has great explanation on use of Tabs and Spaces,

https://am2.co/2018/02/tsql-tuesday-99-tabs-vs-spaces/

Hope it helps you.
Thanks
+1