 | A community of more than 1,600,000 database professionals and growing |
| | | A Supercomputer in My Pocket I work with data on a regular basis, and I really depend on my cell phone to help me with both work and life. I regularly make notes and get ideas for articles and editorials from things that happen when I’m on the go. Without a smartphone, I’d be juggling a notebook and pen, perhaps pulling over and making notes that I’d transcribe later. Since I'm in different cars and vehicles with different bags, I'm not sure how well I'd be able to keep track of notes on paper. In the last decade, as I’ve purchased and upgraded mobile devices, it’s been amazing to me that I can use many services to help me. I can log into something like Instapaper to save an interesting article I might write about later, or capture a few thoughts in Evernote. Or even send myself an email with an idea for a Question of the Day. I’ve done all of those things while in various points when inspiration has struck. In the last few years, I’ve started to use some audio notes for tracking when I'm driving. I might hear something on the radio, or from a podcast, and need to make a note. The power of dictation apps, which have improved tremendously since the early Dragon Speech Recognition days on 486 computers. While I still don't completely trust audio recognition, what I've learned to appreciate is the ability to just record sound with an audio app that I can play back later. There are audio recording apps, though I often just use Evernote. I use a lot of data transfer and storage on my mobile device. So much so that when I switched a couple years ago to the Google Fi, I was disappointed with only having 32GB of storage. It was amazing for a kid that grew up with 300kb floppy disks to think that 32GB wasn't enough, but it wasn't. I was constantly juggling space and deleting things. I recently upgraded to a phone with 192GB, and I'm hoping that will satisfy my need for pictures, video, and notes. It's amazing to see just how far computing has expanded, giving us incredible capabilities on the go that were science fiction a quarter century ago. Many appreciate the ability to review a document or spreadsheet, or even view a Power BI Report from any device. While I don't often have the need, it is nice to know that I can catch SQL Monitor alerts and view data on my phone, or even restart a VM from a cloud shell from my car if I have the need. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.6MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | How SQL Server monitoring benefits your whole organization SQL Server monitoring doesn’t just benefit your DBAs. In this new guide from Redgate, we take you through the different ways a robust monitoring solution has a positive impact across your organization, from your development teams to IT management, and from finance to your C-suite. Download your free copy now |
|  | | SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your free trial |
|
|
|
| | |
 | In this tip we look at some scripts you can use to automate running your DBCC CheckDBs on an alternate SQL Server instance. More » |
 | More and more businesses already use, or plan to use, cloud-based infrastructure (PaaS) as their primary database solution. However, they still need to support on-premise or Infrastructure as a Service (IaaS) VM-based workflows for Development and Test Databases, and this is a perfect task for SQL Provision and Azure SQLDB. More » |
 | Rayis Imayev from SQLServerCentral Blogs (2019-Jan-28) When you work with maps using ArcGIS visual in Power BI, you always have a feeling that it is a... More » |
| | Grant Fritchey from SQLServerCentral Blogs I see more and more people starting to use Azure Data Studio. As it keeps growing and expanding, it’s going... More » |
|
|
| | | Today's Question (by Steve Jones): I have the Buffer Pool Extension enabled and set on my instance. Currently I have a 58GB setting for max server memory and a 100GB file set for BPE. I want to increase this to 200. Which of these statements do I run? - ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION OFF
- ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'F:\memory.BPE', SIZE = 200GB)
- ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION (FILENAME = 'F:\memory.BPE', SIZE = 200GB)
- ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON
- Restart the instance
|
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Buffer Pool Extensions (BPE). We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this table in SQL Server 2017: CREATE TABLE dbo.SalesOrderHeader ( OrderKey TINYINT IDENTITY(1, 1) , CustomerName VARCHAR(30) ) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve') GO Now I run this code to reset the seed. DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0) If I run this, what is returned? SELECT IDENT_SEED('dbo.SalesOrderHeader')
Answer: 1 Explanation: The IDENT_SEED() function returns the original seed value, ignoring the RESEED. Ref: IDENT_SEED() - click here
» Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
ALTER TABLE ALTER COLUMN WITH (ONLINE=ON) blocking - Surprisingly there was some blocking taking place when testing the ALTER COLUMN command online. It was seemingly due to the...
PIVOT data from one table to the other - I have these two tables CREATE TABLE MyTable ( WillField VARCHAR(10), Surname VARCHAR(30), FirstName VARCHAR(30), CellPhone INT ); INSERT INTO MyTable VALUES ('00508093X1', 'Smith',... Distinct is taking a lot of time and want to avoid that - Hi , I have a query which is taking a lot of time because of a Distinct column.Ca any one suggest... Load large fact table - Hi All I need your help. I am working in a project to create a datawarhouse in azure sql server I'am trying to... SQL Script - Hi All, Could you please help me in get the script for below scenario: Table Creation and Insertion: CREATE TABLE .( (50) NULL, ...
Snapshot Replication and T-log not truncating - Hi I have snapshot replication enabled on a database. T-log backups every half hour. Snapshot occurs once daily and changes are copied... Why are my 2 Transaction Logs growing at roughly the same speed? - I think I may have the answer, I just cannot find the definitive version. I have a database with 2...
Group a set records based on particular row value - Create table #tmp(id int,Type char(1)) Insert into #tmp select 1,'F' union select 1,'F' union select 1,'T' union select 1,'F' union select 1,'F' union select 1,'F'... Multiple Filegroups vs. Multiple Databases for better Performance - Hi, I need to add some new tables to an existing database which will have: 1 - much more read/write operations than the...
SQL : Concatenate unique values in rows based on a condition. - I have the following code to concatenate all distinct Aliasnaam per Masjien. Snippet SnippetSELECT , aliasname = STUFF((&nbs Showing 2 parameters "in line" on one line of an output - Hi there I'm trying to work out how to show 2 or more parameters from one column on a line next... control order of execution within a stored procedure? - I have problem where a stored procedure is daily executed as part of an SSRS subscription, but the last of...
Loading data from fields with generic column names to another table with descriptive column names based on a mapping table. - I have recently been working on importing a file that my company receives from one of our partners which has... What Day is this? - I tried to searc for the answer but have come up empty. COuld someone tell me what datatype is being... Login failed for cross domain - Hello All, We have DEV and UAT domain. I am trying to create replication from UAT to DEV and vice versa.... How to code to change text to high case for all tables? - There are about 50 tables in one database and each table including at lease more than 10 columns. How to code... Sub queries In access - i want to join two queries so i can take the count of one query and divided by another query...
Find and replace third occurrence of the string - I want to find the third occurrence of the 'o' and replace with 'A' create table store ( productid int, productdescription... Generating 1000's of report from SSRS in batch format - I have been searching the web, with no clear direction on this issue. The company I work for had me...
Conversion failed when converting the varchar value ', ' to data type tinyint. - I have data that looks like this: ID | NAME 32 | 14 61 | 3 61 | 14 83 | 2 83 | 12 83 | 3 I need a query to return it like this: ID | NAME 32 | 14 61 |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
