Using SQL Server and R Services for analyzing DBA Tasks
Article shows how R Services can help database administrators with their daily work
2019-02-22 (first published: 2017-02-07)
2,700 reads
database administration
SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed
EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.
2016-11-30
2,001 reads
3 Built-In Technologies for Centralizing SQL Server Administration
DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server that can be harnessed to this end: PowerShell is only part of the solution: there is also Central Management Server, Master /Target Agent and the Remote Server Administration Tools. It's time to work out your objectives and pick the most suitable technologies to meet them.
2016-07-05
3,753 reads
Are you bad enough to join the DBA Team
If you've ever had a terrible day, send in your story and Grant and Steve will pick their favorite to be spiced up DBA-Team-style. The winner will also be given a ticket to SQL Cruise 2015. Find out how to enter.
2014-09-10
1,379 reads
RE: Query relational data
I assume you are referring to metadata. Take a look at the INFORMATION_SCHEMA views. For example: SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' This will show you all tables in the database. Look up INFORMATION_SCHEMA in Books Online.
2005-05-26
RE: help with date parameters
Using the DATEPART function will not allow the optimizer to use the index on the reortsentdate column so your statement will force a table scan.For more info on how to work with sql server dates you might want to look at these articles: http://www.sql-server-performance.com/fk_datetime.asp http://www.karaszi.com/SQLServer/info_datetime.asp
2005-05-25
Outcourcing Operations
Outsourcing should be used to free up staff, not replace them. That's a great mantra and one that's being espoused by the Gartner Group to its client. The logic is simple. Much of the IT budget it just "keeping the lights on", the tedious, mundane, everyday stuff that the Operations folks do. By outsourcing these […]
2005-05-04
2 reads
Indexed Views With Outer Joins
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/rcarlson/indexedviewswithouterjoins.asp
2005-05-04
2 reads
RE: please help!!!
Please be carefull not to duplicate posts. Leave replies here http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=178989
2005-04-30
2005-04-29
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers