Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| memory available but excessive workfiles still created - I'm analyzing PAL results during a period of poor performance and finding warnings of excessive "Workfiles Created/sec." My understanding is that these workfiles are created when data being processed is too big to fit into memory and spilled to disk. But MSSQL is only using 30GB of the 59GB max it is allocated, and the […] |
| Auditing selective users - Hi, I am putting together sql server auditing for a certain project. I create a sql server audit object (which writes audits to file). Then I create a database audit specification. First I used public as principal CREATE DATABASE AUDIT specification [DBAuditSpec] FOR SERVER AUDIT [DBAudit] ADD (SELECT, INSERT, UPDATE, DELETE, EXECUTE, RECEIVE, REFERENCES ON […] |
| Create index ... online=ON - Why is this INDEX setting not persistent ? I'm testing this on SQL2019, but I've seen the same thing on SQL2016. I run this CREATE NONCLUSTERED INDEX [ImageActID] ON [dbo].[Image]( [ImgID] ASC )WITH (SORT_IN_TEMPDB=OFF, DROP_EXISTING=ON, ONLINE=ON, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON) ON [PRIMARY] GO Then I refresh and right click on the index and select "Script index as […] |
| SQL Server 2017 - Development |
| simple insert statement issues - Hello, create table #temp2(datename datetime, lastprocessed datetime DEFAULT'getdate()' NULL) insert into #temp2(datename) select distinct convert(date, c.ActualDate, 101) AS [DateName] from dim.calendar c select * from #temp2 I get below error when I run above Msg 241, Level 16, State 1, Line 20 Conversion failed when converting date and/or time from character string. |
| SQL Server 2016 - Administration |
| Adding 3 rd node in Alwayson - Hi, We have 2 node Alwayson setup. Planning to add 3rd node. To add 3rd node, do we need to remove databases from AG and re-configure them from scratch after adding 3rd node? |
| SQL Server 2016 - Development and T-SQL |
| Recommended Reading? Statements, batches, control-of-flow - When trying to create / save / execute a single .sql file containing multiple DDL operations, such as: use database go create procedure [procname]() as begin ------------------ end go use database go create view [viewname] as use database go create anotherview [viewname2] as ..............ETC and getting errors such as "Create View must be the only […] |
| Deduplicating records from monthly table backups? - I have a database that has monthly backups of a table for the past five years... i.e., they copied the table at the end of the month to a table called theHugeTable_mm_yyyy. Now as you can imagine, tables are huge... and the majority of the table data didn't change from one month to the […] |
| @@TRANCOUNT - The question is: What is @@trancount after this SP is executed? I don't understand why the answer is 1. My understanding is for every BEGIN TRAN, @@TRANCOUNT is incremented by 1 and for every COMMIT, @@TRANCOUNT is decremented by 1, so why is the answer not 0? I know it has to do with the […] |
| Administration - SQL Server 2014 |
| Upgrading from SQL 2008R2 SP1 to SQL 2014. - Hi guys, I'm planning to perform an upgrade on my current SQL server 2008R2 SP 1 to SQL Server 2014. Based on my current license limitation 2014 is the max I can go. I read KB by Microsoft, I need to be on at least SP2 for the upgrade to be successful (https://docs.microsoft.com/en-au/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-2014) if this […] |
| Development - SQL Server 2014 |
| Guaranteed Varchar to Date conversion - I regularly load in multiple files using SSIS into a staging table and then onto another table (I call them trans as they are never fixed). The data goes into stage as it comes out of the file or other source. This way I can always prove I took in what I was supplied. Stage_policy […] |
| SQL 2012 - General |
| BUY 100% GRADE AAA+ COUNTERFEIT MONEY whatsapp::+13232503649 - We are the best and Unique producer of HIGH QUALITY Undetectable counterfeit notes and fake documents. With over a Trillion of our products circulating around the Globe. We offer only original high-quality counterfeit currency NOTES and fake documents which can be used anywhere ,anytime .These notes are of the highest quality. Korean made notes often […] |
| SQL Server Newbies |
| * to 1 - Can I replace the * with 1 here in the below code. Will it impact the result. IF EXISTS (SELECT * FROM dbo.tbTest where Test_ID = @Test_ID) -- Like change to SELECT 1 |
| Azure Machine Learning |
| Why no posts? - I've heard Microsoft promote their concept of the "modern data warehouse" and their tools to support machine learning. In my mind, there are at least 2 big components embedded in what they say: marketing to promote adoption of their cloud services and genuine opportunities to add value to the community. When I hear the word […] |
| Integration Services |
| Automate the SSIS package to take Start and enddate - I have a master/parent package, that calls the child packages in SSIS. The Master package takes the startdate and enddate and get all the dates from the given Startdate and enddate and run the child packages in loop. Example: Startdate = 1/1/2019' and Enddate ='1/10/2019'. SO the Master loops through 9 times meaning 1-9th january […] |
| PowerPivot |
| Power BI Data Gateway - Azure VM v On-Premises - When you have a SQL Server instance running in an Azure VM and you want to connect Power Bi Data Gateway to it, do you install the Data Gateway or is there another way for Power BI to get the data, considering it isn't technically "On Premises"? |
