Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
sys.dm_db_file_space_usage - I've been reading up on sys.dm_db_file_space_usage and see a lot of examples of how to convert the results to MB / GB. However, none these methods work for me... or if they do, I don't understand them. When I run use tempdb; go select * from sys.dm_db_file_space_usage; For the total_page_count I get 85184.00. That's […] |
SQL Server 2017 - Development |
Global Temporary Tables and dynamic sql string - I have a script: if OBJECT_ID('temptable') is not null drop table temptable go if OBJECT_ID('tempdb.dbo.##t') is not null drop table ##t go create table temptable(EmployeeID varchar(50), ProjectID varchar(50)) go declare @s varchar(4000) set @s = 'SELECT top 10 T.EmployeeID into ##t FROM temptable T' exec (@s) set @s = ' drop table ##t SELECT top […] |
HTML Mail with more than one line in Resultset - Hello all, i would like to send a html Mail with sql server. But i can´t solve it by more than one line. Resultset: Select car,model,engine from cars Honda, Civic, 1.6 VW, Golf, 1.5 Dodge, Viper, 8.4 In my Mail i would receive a html table with:[…] |
SSIS Export Flat File as Fixed Width - Hi Forum, I have a table that uses the script below to create fields with Spaces at the start of the field value. The way this works is if,for example, a field length is set at 12 characters and the value for the field is 8 characters long, it should have 4 spaces at the […] |
SQL Server 2016 - Administration |
Index Maintenance - I need a query to find the unused indexes and missing indexes on all tables in a database.also for creation of index recommendations on tables. |
SQL Server 2019 - Administration |
WSFC option missing in Availability Group Wizard - Hi, I have installed SQLServer 2019, and Windows Server Failover Cluster feature. I want to create a AO Availability Group. I start the create wizard, and in the "Specify availability group options" page the WSFC cluster type is missing. I only can choose EXTERNAL or NONE. Is there something I am forgetting? From what i […] |
Using MS SQL Server Security mechanisms in a three-tier architecture - I am trying to understand how I can use the db server authentication - authorization mechanisms and user related tables, but I cant find any resource simple enough to grasp the whole concept. What I am trying to do is to not have my own tables for users, roles etc. but use the platform's syslogins, […] |
SQL Server 2019 - Development |
Nested Json Parsing issue - Greetings, I am having issues parsing the following Json string using openjson. I am having problems getting at the piece under custom fields. If I omit that, I can bring in the rest of the fields. Looking at other posts, it looks like it requires multiple cross apply statements but I haven't got the syntax […] |
Reporting Services |
SSRS 2014 - Page Break to follow a sub-report? - Hi everyone, Really really need help on this one. You would think that page breaks would be easy to do, but alas, SSRS is not doing what I told it to do. Of course, I am assuming that I simply haven't told it the exactly correct way to go about it. I have a report […] |
SSRS 2016 |
SSRS Branding - Different Font Colour for Primary and Secondary Bar? - I have followed a few different guides for branding SSRS and these all work but it seems impossible to have the text in the first bar (top-right showing Settings, Download and Help on same line as the logo) to be different to the bar below this (showing Favorites and Browse). The logo is dark blue […] |
Analysis Services |
AS Tabular and Sample Data in VS - Hello all, I really need your help – I want to use the sample data in an Analysis Services Project in the Visual Studio, but the sample Data from the Sample Partitions will not be displayed. The actual situation: I use a Tabular AS Server 2016 and 2019 Visual Studio 2019 with the latest Data […] |
Anything that is NOT about SQL! |
Replacing Remote Desktop Connection Manager - So RDCM is no longer being supported by Microsoft, but it was such a useful tool. I'm looking for alternatives that have the ability to group server connections and save those names so I don't have to type them in every time. Any thoughts on a good replacement for it? |
COVID-19 Pandemic |
Daily Coping 26 May 2020 - Today’s tip is to share an inspiring quote with others to give them a boost. My thoughts: https://voiceofthedba.com/2020/05/26/daily-coping-26-may-2020/ |
Daily Coping 25 May 2020 - Today’s tip is to share photos of 2 things you find meaningful or memorable. My thoughts: http://voiceofthedba.com/2020/05/25/daily-coping-25-may-2020/ |
Article Discussions by Author |
Microsoft SQL Server Utilities and Tools - Comments posted to this topic are about the item Microsoft SQL Server Utilities and Tools |