|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Even More Memory Optimized Table Limitations | |
In SQL Server 2017, can I truncate a MOT 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) |
Wargames Quotes What is the famous quote from Wargames that the computer says to the young human (through the speech box) when he first connects? Answer: Shall we play a game? Explanation: When he first connects, the computer asks him "shall we play a game?". Later, the more famous line is "Would you like to play a game?" Ref: https://youtu.be/7R0mD3uWk5c?t=74 |
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 |
SSIS Package on a different server - Hi, I have SSIS on server1 and the database on Sever2. When I try to run the package it runs successfully however when you run it from the web server it says sp_start_job 'job_name' does not exist as the package is on server1 but needs to connect to the databases on server2. What am I […] |
SQL Server 2017 - Development |
convert dynamic rows to columns in sql server - Hi i have one doubt in sql server how to convert rows to columns dynamically in sql server CREATE TABLE [dbo].[product]( [productid] [varchar](20) NULL, [productEventID] [varchar](50) NULL, [productTransID] [varchar](50) NULL, [productEffectiveDate] [datetime] NULL, [productInvestmentID] [varchar](20) NULL, [productBuySellCode] [varchar](10) NULL, [productClosingValue] [decimal](13, 2) NULL, [productClosingUnits] [int] NULL, [productChangeInUnit] [varchar](20) NULL, [productChangeinvalue] [varchar](20) NULL, [productNAVPriceDate] [datetime] NULL, […] |
Workaround maximum length for a nonclustered index in SQL Server - Hi, hope everyone is well. I need to create a unique nonclustered index but that key lenght is 17oo bytes. I know the work around is to create the index with include. My question is: would that index with unique be unique? Will an insert fail if it is breaking the logic of the unique […] |
SQL Server 2016 - Administration |
Loading & downloading files to/from a Full-Text-Search database - Hello everybody, I come across full-text search (FTS) everytime I study for an MCP. It has some very specific uses which seem very useful. I have been asked as to whether making the user-created files on a particular server searchable is possible by means of FTS. In theory, yes, it is, from what I read […] |
Change database owner - Hi All I would like to change database owner in databases which part of AG group and act as secondary replica so when i tried to change the owner , it give me error : "Failed to update database because the database is read-only" What should I do ? Your feedback is much appreciated Thank […] |
Administration - SQL Server 2014 |
How is access (read,write) granted to NT user logins? - I have a user who is trying to edit a Crystal report. She is getting ODBC errors. When I investigate, I first log using her credentials. When I open OBBC32ad.exe and examine the System datasource, the database tied to this Crystal report is not listed in the drop down of Databases. If I log into […] |
Index Optimize - Based on my understanding during the index optimize it will not take the whole database down. However, there would be impact on the performance. Do you agree with this? If yes, would you schedule any jobs during the index maintenance? |
Development - SQL Server 2014 |
Search with Full Text Index vs "normal" search - Hello, i need your help because i am feeling bad with Full text index. I need to do a search for clients, so i have implemented a full text index on my table "b_utentes". My code is fine, is working very well. But, someone ask me to do a code without use of full text...ok, […] |
SQL 2012 - General |
Always on DB - Log huge and no free space - Hi, So I've got an Always on database that is 1.4TB in size, the Always on is working fine but the log file just keeps on growing, as of now is at 683GB in size with less than .1% free. We have regular log backups and I need to find out whats using all this […] |
SQL Server 2012 - T-SQL |
Adding another table to a query but only wanting the top 1 for each record - I currently have query that gives me the results i needs BUT i am needing to add a new table/column to the query. select name, state, id, (case when custapps.app = 'GLG' then 'GASB' else custapps.app end) as app, version, maddr, city, zip, customers.phone, contacts.sort, contacts.email, install_date, population, customers.notes, CASE databasetype WHEN 1 THEN 'Vision' […] |
SQL Server 2019 - Administration |
How to deal with SqlServer PS module - I understand that SqlServer has replaced SQLPS. I experienced this with SQL 2017. I'm now putting together a SQL 2019 with server 2019 and I see that SQLPS is still part of an install. PS C:\Windows\system32> get-module sqlps -ListAvailable Directory: C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules ModuleType Version Name ExportedCommands ---------- ------- ---- ---------------- Manifest 15.0 […] |
Reporting Services 2008/R2 Administration |
Why can't I Manage Reports on SSRS site? - Hello, I'm an admin on this SSRS site and I can browse and upload reports with no issue, however, when I click on the report drop down option and select Manage, in order to assign the data source and properties, etc. I keep getting the HTTP 404 error Webpage cannot be found. This site was […] |
SSDT |
Expression with multiple IFs - I am trying to create an expression to derive a data column value based off two other data columns. In English If VARA is greater than three characters long an the first character is "1" then VARB = VARC + ".A" + the last two characters of VARA ELSE If VARA is greater than three […] |
Analysis Services |
DAX table joins - All, I'm trying to improve my understanding of cubes and DAX but I'm missing something. If possible I would appreciate being pointed in the right direction. My model has two tables - Post and PostTypes. Post is the fact tables and PostTypes is a measure table. There is a link, within the model, between Post.PostTypes […] |
T-SQL |
pulling multiple numbers out of a string - I need help pulling multiple number values out of a string field name is Details and here are some examples of the values DETAILS Maximum width is 13'2", maximum length is 30'. Minimum total size for all custom rugs is 25 sq/ft. Maximum width is 15', maximum length is 25'. Minimum total size for all […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |