|
|
|
|
|
|
|
Question of the Day |
Today's question (by Evgeny Garaev): | |
Zero or Hero? | |
What will be result of this query:
IF (1 <> 0) BEGIN DECLARE @NumOfHolidays INT; SET @NumOfHolidays = 0; END; SELECT @NumOfHolidays; | |
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) |
An anonymous lambda in python In the Python REPL, I run this with these results: >>> lambda y: y+5 at 0x0000020DDC55F0D0> How do I run this function? Answer: _(5) Explanation: The underscore in the REPL will execute the last expression evaluated. Ref: Anonymous Functions - https://realpython.com/python-lambda/#anonymous-functions |
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 |
Flat file import - I am importing a flat file from a network share which is dropped there by an application and populating a table. Now there is an additional requirement from the application team to have these files perform updates to existing records. I'm thinking updates need to be scripted and run manually as a query rather than […] |
Memory Optimized Tables, UDF and Cross DB access - Hi everyone. I have a database call DBMemOpt with a memory optimized table tTableMemOpt I create a table value function in DBMemOpt in this way: USE DBMemOpt GO CREATE OR ALTER FUNCTION [dbo].[fTest_MemOpt] (@param as int ) RETURNS @fooTable TABLE ( idintNOT NULL, foointNOT NULL ) AS BEGIN INSERT INTO @fooTable SELECT id, foo FROM […] |
SQL Server 2016 - Administration |
is Forced Parameterization usually more beneficial than less? - On a hybrid server, with ~70% OLTP vs 30% (somewhat heavy) DW workloads, with over 60% of all heaviest recompilations coming from AdHoc queries: We view the recompilation reasons via the Histogram (via the below XE Session) and querying it (also below) that produces this result (this is for most recent 24 hrs). Should I […] |
csv export has line returns from a column on one server not the over - Ok i have a test server and a production server. (I did not set up) . On the test server when I export the query results to a csv vile one of the column (workinst) has line returns so the sheet is messed up with line returns and the following columns are no longer on […] |
How to get spid of jobs that are running along with job name - Hi, Can you please let me know how to get spid of jobs that are running along with job name Thanks |
Administration - SQL Server 2014 |
Linked Server to MS Access Database - Hello all - I am hoping someone here can help shed some light on what I am seeing in my environment. I have a SQL Server 2014 Standard (12.0.4100.1 (X64)) installation. On this server, I created a linked server to a Microsoft Access Database called Property, which lives on a separate windows file server. The […] |
Development - SQL Server 2014 |
SSRS + SSAS Issue - Hi I installed analysis services/ reporting services on SQL 2014 server and then restored databases -report server and report server tempDB and also restored the analysis databases from SQL 2012 server. The issue I am now facing is while configuring SSRS reports and giving a connection string as below : Provider=SQLNCLI11.1;Data Source=xx;Integrated Security=SSPI;Initial Catalog=xx […] |
SQL Server 2019 - Administration |
Loop thru DIRs and COPY latest BAK file to our DR Dir - I need to LOOP thru our Ola Hallengren gen'd backup DIR's to identify the most current FULL backup file and COPY it to a D/R directory (our Server team will then copy the files in the D/R directory t tape and ship offsite). I only wnat the single, most current FULL backup file copied fro […] |
removed - removed |
new sql installation of developer edition errors - I am learning to work with SQL server 2019. During the installation I got some errors. TITLE: Microsoft SQL Server 2019 Setup ------------------------------ The following error has occurred: Cannot find the user 'DESKTOP-QGVGUB6\PdwComputeNodeAccess', because it does not exist or you do not have permission. Changed database context to 'DWConfiguration'. Script version: 107 Version_History table created. […] |
Irritating bug in the 2019 SQL Installer - When installing SQL, be careful on the Server Configuration\Services Account page when you select the "Grant Perform Volume Maintenance Task..." option. Even if you have selected an Active directory account for the services to run under, the right is actually assigned the SQL Server Managed Account NT SERVICE\MSSQLSERVER and NOT to the account you have […] |
General |
Update table from other tables - Hi, Basically i have 2 tables check-in and check-out where users check-in and check-out using a RFID card. I am wanting to display who's in the building or been in the building on a given day. I have a VB.net program writing to the tables how in SQL would it best to display this data. […] |
Integration Services |
How to copy data from Salceforce to SQL SERVER tables - Hello Good Morning, I have about 8 tables in salceforce i would like to copy/load them into sql server daily. (just truncate and reload) in sql server. but automated way not manual loading. please share any thoughts or ideas... Thank you Asita |
C# Script for sending email - Can anyone help me with some script to send email with C#. I tried the "Send Mail Task" and it failed also. Here's what I have so far. It runs but I get no mail. My port number is 25 and I'm using basic authentication with password. Any ideas?: public void Main() { try { […] |
SQLServerCentral.com Website Issues |
private messages gone - hi, Maybe I'm doing something wrong now, but it seems that the option to look at my private messages is now gone from my profile - did had a few private discussions with members and can't find the option anywhere now. |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |