Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
SQL Express Backups ? - Without a 3rd party tool, what's the best way to backup SQL Express, not having SQL Agent ? A Windows Task Scheduled to run a backup script, and delete old backups ? |
Admin Permissions...Or Not - A vendor installed SQL 2017 Express on a new server. I am in the Windows Administrator group, but do not have access to anything useful in SQL, when I RDP onto the Server.. Computer_Management -> Groups -> Administrators -> DomainName\MyName What are some reasons I would not have access ? |
SQL Server 2017 - Development |
Sort Query by Data from another table - Hello: What is the best way to sort a query based on defined priorities in another table. I have my main 'Schedule' table here... And I want to sort the WorkCenterID column by the values in this table, 'Operations'. I am playing around a little with Joins, but I'm not even sure I'm on the […] |
SQL Server 2016 - Administration |
NT AUTHORITY\SYSTEM Schedule Backups - SQL 2016 EXPRESS - Hi I'm trying configure best backups pratices in Windows server 2019 using sqlcmd in Windows Schedule Tasks with NT AUTHORITY\SYSTEM account, but it's not working... It only works if a setup this account with sysadmin role, if I setup only with public role I get this error: Msg 229, Level 14, State 5, Server […] |
Moving database files to another drive - Hi all For background, we ave two servers (DEV and PROD) and they are set up slightly differently. On DEV, the mdf files are stored on the E: drive, on PROD the mdf files are stored on the D: drive. What I'd like to do is change the drive on the DEV server […] |
Huge size of Reporting tables - Hi All We have a DB for reporting which has tables which are more than 5 TB in size. As the business grew, we reached at these sizes. These tables have 1 month worth of data and we need this much data to generate many of our reports. So we can archive or purge these […] |
sql backup for big database in 4 steps - Hello, Can someone help me with code for sql backup for big database in 4 steps so it will not take a long time to do a back up. Thank you |
SQL Server 2016 - Development and T-SQL |
COUNT(ID COLUMN) not using Clustered Index - Hello SSC, Ok, so I have a table that has a 1 Clustered and 1 Non-Clustered Index. PK Clustered Index is simple, just CustomerID, unique, straight forward. Non-Clustered is a combination of 3 columns that do not include CustomerID. When I run... SELECT COUNT(CustomerID), the execution plan shows that it is hitting the Non Clustered […] |
SQL 2012 - General |
Msg 537, Level 16, State 3, Procedure Recover_Truncated_Data_Proc, Line 113 Inva - I work on sql server 2012 i call procedure name as below EXEC Recover_Truncated_Data_Proc 'Nahdy','dbo.Student' I get error Msg 537, Level 16, State 3, Procedure Recover_Truncated_Data_Proc, Line 113 Invalid length parameter passed to the LEFT or SUBSTRING function. so How to solve this issue please this table dbo.Student USE [Nahdy] GO /****** Object: Table [dbo].[Student] […] |
SQL Server 2019 - Administration |
Execute a script on the Azure Database - I am trying to execute the script below on an Azure database, I am doing because the scripts file is big i scripts schema and data from another Azure database. I I have the script above, I need to run on my Azure Database but is is giving error that you must specify an elastic […] |
How to create a SQL clusters in oracle? - Hello Iam a Newbie, can you guys help me out that how to create SQL Clusters in oracle? Help appreciated Thank you |
MS Server Management Studio 2018 - I donwload the above with the Azure Data studio and it does not contain a connection console to the database. Please assist? I got it from here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 |
SQL Server 2019 - Development |
Need help on my SQL - Hi there, I need help to use SQL to pull data from SQL Server and feed it to Tableau as data source, but I am stuck and not sure what to do. Here is the requirements for the report. Assume I run the report on Tableau dashboard today (04/08/2021) (Note: user can select the report […] |
Entry point in sysdatabases - Newbie to this .. will learn .. am motivated. When I do a script for creating a new database I get this error: Could not locate entry in sysdatabases for database (the name of the one I wish to create.) I do not understand why I must have a name for my new database in […] |
SQL Server 2008 - General |
Top 5 by user query - Hi All, I want the earliest 5 distinct dates for each user. I know I can row_number() over partition by user order by date, but there are a lot more than 3 users and a lot more than 12 dates. I'm having a moment here, and I'm pretty there's a much simpler solution. This will […] |