|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
SQLCMD Output | |
I am working on a SQLCMD script. I have this written:
:setvar DirectoryRootPath "C:\Users\Documents\Log.txt" :connect PlatoSQL2017 XXX select * FROM dbo.LoggerWhat do I put in place of the XXX to get the data from the table into the file specified in my variable? | |
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) |
Still More Memory Optimized Table Limitations If I run DBCC CHECKTABLE on a table in a SQL Server 2017 database that is Memory-optimized, what happens? Answer: The command fails and an error is returned Explanation: The DBCC CHECKTABLE command is not supported for MOT tables and returns an error. Ref:
|
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 - Development |
Programmatically create SSRS report as PDF - I would really appreciate some guidance on how to get vb code working in a SSRS report. Please refer vb code at end of posting. The code has been added to Custom Code (Report Properties, Code) and the code is called from a Text Box expression in the report. I have created a SSRS Data […] |
How to check if a particular table is being used right now? - I am completing an SP that will do massive deletes based on certain criteria from a dozen of tables. On average each table is tens of millions of rows, no permanent or tuned indexes on it (it is a staging-swap kind of tables, temporary transactional data holders) but occasionally heavy selects can be run against […] |
Running Total - I have a table that captures rainfall data approx every 10 minutes. I want to calculate a sort of a running total of the Last Hour's Rainfall and the Last 8 Hours Rainfall by Time. Last Hour's Rainfall = Sum(PrecipitationAmount) for the previous 60 minutes (PrecipitationMinutes is the number of minutes over which the PrecipitationAmount […] |
SQL Server 2016 - Development and T-SQL |
Need some help getting info of people logged in, but from the POV of NON-Sysadm - I modified a proc that returns a result set of all user emails to the application in question, with one column that displays a sundial if that user is logged in. I did this by doing a left outer join to sys.dm_exec_sessions Left join sys.dm_exec_sessions b on login_name = Su.name and program_name like ' |
I was asked to get rid of this Dynamic SQL for performance purposes. - Is it REALLY possible to bypass the @Where_Clause variable and make the below SQL non-dynamic? This is a statement from an SP that receives the below 5 parameters and dynamically builds the WHERE clause from them. I don't think it is possible NOT TO USE DYNAMIC SQL HERE, but double-checking with you guys. Thanks. -- […] |
Need explanation for below query what it does - @Date1 = '20150630' DATEADD(m,6, @Date1) < DATEADD(m,-12,GETDATE()) Ignore this, i got the answer after validating. |
Administration - SQL Server 2014 |
SQl Stored Procedure - View Tuning - Hi, We have a stored procedure which calling view which contains bunch of tables in sql 2014 and 2017 and it's slow. View contains roughly 100K records. I was looking view and based on joins and where clause i have created index but nothing gain as performance it's same. I tried following: Created Index based […] |
SQL Server 2012 - T-SQL |
Concatenating to a string - I am trying to concatenate values into one string value and what i have so far is progress, but I want to encapsulate my variables with single quotes. The below gives me e.g. Karen,Cox,Oakland,MN,95573 when what I need is 'Karen','Cox','Oakland','MN','95573': p.firstname + ',' + p.lastname + ',' + i.city + ',' + t.stateAbbrveation + ',' […] |
SQL Server 2019 - Administration |
Gauging Performance Improvement after removing the unused indexes - Hi All, Removed some of the unused indexes. But, how to identify the performance improvement? Is there anyway to generate any metrics and giving that the managers? Regards |
SQL Server 2019 - Development |
PowerBI Report Builder - can it use/declare variables? - In SSRS, creating your own variables for use within your report is trivial... did MSFT leave this out of PowerBI Report Builder? In SSRS, I could create a dataset, and create a variable, and set the value using an aggregate for example (like a count of records in a dataset). I'm trying to do the […] |
Ensuring a randomly generated number is always 8 digits - Hi there I have inherited a piece of code which generates an Activation Code based on a seeded value as follows select cast (round(rand(31303258 * rand(DATEPART(millisecond,GETDATE()))) * 100000000,0) as int) where 31303258 is the seed or another 8 digit number Now what I have noticed is that not all the time, a 8 […] |
Reporting Services |
Programmatically create SSRS report as PDF - I would appreciate some guidance on how to get vb code working in a SSRS report. Please refer vb code at end of posting. The code has been added to Custom Code (Report Properties, Code) and the code is called from a Text Box expression in the report. I have created a SSRS Data Source […] |
SSRS 2016 |
SSRS 2016 - force page break - Hello, How it is possible to dynamically force a page break? for example: if the final page is on pagenumber say number 9 then have a page break before this page? Thank you |
Integration Services |
View package that has been deployed - First an explanation just to see if I am going about this the right way I have a package that i've created using VS 2017 If run it from VS2107 i.e. locally, it works fine I've created a SQL Agent job Now, if I deploy it via SSMS i.e. through deploy project in […] |
SSIS & Azure SQL database - Hi , I have an on-premise SSIS package which connects to SQL Server database(Source). On connecting source using onpremise SSIS need to connect Azure SQL database , after connecting Azure SQL database need to truncate the stage table first and insert the source data. On success of source data to destination table (stage table), need […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |