|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Developer Permissions | |
I have created a new database on a development server and added the user, JoeUser, as a user in this database. This user has no rights other than to connect to the database. I then execute this code:
CREATE SCHEMA Dev GO GRANT CONTROL ON SCHEMA::Dev TO JoeUser GO GRANT CREATE TABLE TO JoeUserJoeUser then connects and runs this code: CREATE TABLE Dev.MyTable (myid INT)What can JoeUser run successfully on this table? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Quantums The time a worker can remain active in a scheduler is called the OS quantum. What is the maximum length of time for a quantum? Answer: 4ms Explanation: The maximum is 4ms. Not sure that matters to any of us, but it's an interesting trivia question. Ref: SQL Server task scheduling - https://docs.microsoft.com/en-us/sql/relational-databases/thread-and-task-architecture-guide?view=sql-server-ver16#sql-server-task-scheduling |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
limit parsing a XML -datafield from one server to the CMS using Powershell - Guys, I do need some help on a limit parsing a XML -datafield from one server to the CMS using Powershell --------------------------------------------------------------- I registered some servers in a folder in the CMS (SSMS). On each server there is a DBA-database holding the XML_REPORT table and a Stored-Procedure (which generates a XML-report). On the CMS itself […] |
SQL Server 2016 - Administration |
TDE: Database Encryption key to be changed from 128 bit to 256 bit encryption - Hello, I was asked to apply TDE using 128-bit encryption initially. Later on, the new requirement governs to change that to 256-bit encryption. Without dropping the DB encryption key, can we change that from 128 bit to 256 bit encryption? Thanks Sourav |
Query to remove all databases from AG - As part of DR we need to remove all the databases from different AG's , each AG is consists of 20+ databases , i need a query to generate script for removing all databases with respect to specific AG group , . Thanks,. |
SQL Server 2016 - Development and T-SQL |
pull data every 3 hrs - I'm trying to pull data every 3hrs between 2 dates. I need to just get one record for each machine every 3rd hour between two dates. I have this query which reports back midnight the day before thru today, but I'm looking for a single CREATE TABLE [dbo].[mach_data]( [dtstamp] [datetime] NOT NULL, [equipment_id] [varchar](6) NOT […] |
Help Understanding A SQL Script - Hello Community, I am trying to implement a SQL Script from this link, and pasted below --================================================================================================= -- DESCRIPTION --================================================================================================= -- The purpose of this script is to create a set of database views in a database within your Synapse Analytics Serverless SQL Pool that will -- translate numeric codes for Option Sets, Status and […] |
Administration - SQL Server 2014 |
Sudden rise in memory - Hi How i can check which process was run that Sql memory suddenly increased. Thanks |
Development - SQL Server 2014 |
SSRS Rendering format Excel Change ? - I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file so the default cell format is text and not General. If not, is there any way to format my fields in the stored procedure so when I download to Excel it formats as text? Thanks |
SQL 2012 - General |
Urgent help needed. MS SQL Server 2012 - Hi, I've just got a call (6pm on a Friday!) from a customer who has had his line-of-business application provider sell him a solution which required SQL Server 2012 Standard, yet the supplier (joyfully) installed the evaluation version of SQL Server 2012 Enterprise. This has now ticked over and expired. My problem is that (a) […] |
Merge Replication or Back up and Restore - Hello I have a database copied on two servers. Same name. I have tried a merge replication but it keeps failing on various objects. I have removed objects one by one and left with the bare minimum tables and still won't work. Users won't mind using one database as master and do all the updates […] |
SQL Server 2019 - Administration |
Extending High Availability Group into Azure - Hi I've been asked to extend a HAG which is currently on premise to include an azure vm sql instance. currently i have a 3 node cluster, two nodes in on city with synchronous connect and auto failover and one in another city with asynchronous connect and manual failover. I want to add an azure […] |
SQL Server 2019 - Development |
Parse SQL data - Below is the test data. What I am looking for is... I want to PARSE any value starting with PD- from the description column. Below is sample data. However, it could be possible the "Description" column could have n number PD id in the column, not restricted to any numbers. Any advice would be highly […] |
General Cloud Computing Questions |
Client doesn’t want to run discovery agent, what are the options ? - Trying to assess client on-Prem servers for a cloud migration. We usually run a discovery tool that runs an agent to capture high level server info (OS/ Softwares/CPU etc…). I’m trying to think out of the box solutions. Maybe ask him to run his on script to capture all data or deep dive session to […] |
Integration Services |
Replace function in SSIS Expression - hi, I have files that are coming in .txt files. Example MA.textfile1.txt ,MA.textfile2.TXT . I need to replace the file name after i process these files. I have a foreach loop to get the file names , and file system task to rename files. However i have set up variables within file system task, if […] |
Suggestions |
Add a resolution flag that can be set by the OP - Something like the following. Thanks! |
Anything that is NOT about SQL! |
Web site font colour/background colour and readability - Hi everyone I'm just interested in getting peoples about the readability of many web sites as far as the general words in sentences (not headings). Maybe it's my imagination, but it seems to me that there seems to be a tendency for there to be a lack of contrast these days between the font colour […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |