Drive space check SQL server steps and scripts
AdvertisementsFollowing is the script used for drive space related issues.
--SQL 2000
-- select name,(size/128.0) as size_mb,* from master.dbo.sysaltfiles order by size_mb...
2018-11-13
679 reads
Random Pix from the 2018 PASS Summit
A few memories from me. First, a beautiful late arrival view.
My first session feels a little lonely
It started to fill...
2018-11-12
789 reads
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...
2018-11-12
43 reads
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R?
A few months ago, I asked myself an important question – which language to learn first...
2018-11-12
663 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...
2018-11-12
23 reads
Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018. I will be presenting two sessions, What is Power...
2018-11-12
15 reads
Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018.
I...
2018-11-12
164 reads
Bad Query Performance Tips Rebutted
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over...
2018-11-20 (first published: 2018-11-12)
3,248 reads
A New Video - Create a DB Executor Role
A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There...
2018-11-19 (first published: 2018-11-12)
1,840 reads
Load and run custom T-SQL scripts in SSMS via Snippets
If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...
2018-11-12
376 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers