Laden...
|
|
|
|
|
|
|
| Question of the Day |
| Today's question (by Steve Jones - SSC Editor): | |
| Running Steve's Code | |
| Can you run this code in any of your SQL Server 2019 databases without error? CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GO | |
| 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) |
| A Strange Result What does this code return in SSMS 20 from SQL Server 2019? select '|' + CHAR(0)+'abc' + '|';Answer: It depends on whether results are in the grid or text Explanation: It depends. The grid format returns |, and has trouble with the char(0). The text format shows | ABC|. ;) |
| 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 2016 - Administration |
| Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing - First time here...hoping I can find some direction and answers so I can devise a proper solution. Novice Basic SQL experience over the years while being the "jack of all trades' IT support, not a DB admin by any means. Issue: After vendor Application upgrade and SQL upgrade from 2014 to 2016 we cannot process […] |
| Issue with DBMail - Hi all We've got 3 servers with the same setup for dbmail. They use the same account (just with a different display name as replies are ignored) and every was working perfectly until this weekend. I've now only got 1 server out of the 3 that is correctly sending emails automatically. Server1 is running […] |
| SQL Server 2016 - Development and T-SQL |
| Counting values with hysteresis in Report Builder - Hi, I have a set of data (for instance sine wave) and I need to count, how many times have value reached above lets say 75%. Is there a way to do that in Report builder ? Thank you JK |
| SQL Server 2019 - Administration |
| Agent job security account - Hi All, I have few sql server agent scheduled jobs which are supposed to run as NT Service\mssqlserveragent account however at times it runs using different account. Being novice in this world , I am not able to figure out where to make the change in agent job security to ensure that it only and […] |
| Export database and tables no table data - Trying to move a database from one sql server instance to another on separate servers . I need to only move it like a skeleton no data and looking for steps to export the database and tables. Is this possible? |
| SQL Server Newbies |
| normal role member to be able to view list of other role members in his DB - Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and [sys].[database_principals] can not be accessed even with grant . |
| SQL Azure - Development |
| How to manage Time zone changes for countries - Hello Everyone, I am using Microsoft SQL Azure (RTM) - 12.0.2000.8, as of October 2, 2024. This software is copyrighted by Microsoft Corporation in 2022. We have developed a ticketing system currently used by around 30 countries, and we expect this number to grow in the coming days. To maintain each country's local time, we […] |
| SQL Azure - Administration |
| Azure elastic job issue authenticating to Azure SQL database - Azure elastic agent jobs: I’m getting this error “The server principal “ac1971e9-381b-449b-9e1a-9cc276fc2985@b5313c9d-fb0d-47af-bc87-7c050bffbdc3” is not able to access the database” when an elastic agent job tries to run against a new database that has been added to an elastic pool. The elastic pool is configured as a target group member. For all other databases in […] |
| Connecting |
| SSMS 20.2 on Windows11 not able to connect to SQL 2005 ?? - We still have a couple of dino's. What should I check to re-enable access to ye good old SQL 2005 on Windows 2003 for my SSMS 20.2? I have already accepted "use server certificate" and "optional encryption" Still doesn't work; "SSL Connection forcebly closed by server" btw: When using SSMS 18.12.1 it works fine |
| Integration Services |
| Package to Project model conversion - Hi All, With previous customer range we were always required to work in the traditional package model approach were individual packages were stored in deployment folders and combined with configuration files. (Usually old 2008R2 SQL server versions) For my current employee I have the liberty to setup everything from scratch using newest versions of everything. […] |
| SQL Server 2022 - Administration |
| Converting job_id to join to another table. - I need help, please! I have a monitoring table that pulls in information about program name (plus sp_who2 does as well), and I need to join it to msdb.dbo.sysjobs to get the job name where the program name starts with SQLAgent (like SQLAgent - TSQL JobStep (Job 0x8FA89775AAF135499FA4CC1621B639FB : Step 1)). Nothing I try is […] |
| How much transaction logs generated by hourly/daily - For MSSQL is there any queries or methods for me to pull historical data of transaction logs generation? I know that for Oracle database we can run a query to extract the amount of archivelogs generated hourly/daily. Is it possible for MSSQL? I have an hourly TLog backups running on the database, so currently I'm […] |
| Export Data-tier Application vs Generate Script: Why Does SQL Server Have Both? - Hey everyone, SQL Server has two mechanisms for deploying and moving a database to another platform: Export Data-tier Application and Generate Script (with the "schema and data" option enabled). I'm a bit puzzled because these are two different tools that seem to tackle the same task. From what I've read and tried, they appear almost […] |
| SQL Server 2022 - Development |
| A Design Question using a fictious example - Background: I have two tables. Tests and Grades. For each Tests record there are many Grades; one for each student. The Grades table has a field called: StudentsGrade. Each time a Tests record is inserted into the database, an associated Grades record is inserted into the database, one for each student where the value of […] |
| Generating (semi-)fake purchase data - I know how to generate fake data (thanks to Jeff Moden's articles!)... the problem is that I'm trying to generate purchase data where the unit price of a product increases on some products over time. Normally, I'd get the changing price information from all the purchase invoices, but I don't have those. So I have […] |
| |
| ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. [email protected] |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...
