SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,841 questions
3 answers
One of the answers was accepted by the question author.
SSIS Script Task
I have a table which has the list of files in a column Column values are File1.csv, File2.csv etc. Now in SSIS I would like to retrieve the list of files from the above table and then check if each file is present in a directory. If a file is…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 72%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
4 answers
SQL Triggers
Hi, I need a help regarding SQL Triggers. I think I'm making a mistake that is why it is not executing well. I'm developing an application which have PURCHASE, PURCHASEDETAILS, LOGS tables. What I need here is that when I make a purchase and…
asked 2020-08-23T16:53:12.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ranjith
1
Reputation point
commented 2020-09-04T21:56:30.097+00:00
Erland Sommarskog
102.1K
Reputation points MVP
2 answers
Have Report Builder forget saved credentials
Using Report Builder 3.0 for SQL Server 2014. I need to have it forget some user credentials forgotten when connecting to a report server. I have tried deleting the user config file, the clear all recent item lists option, and uninstalling and…
asked 2020-08-17T15:56:02.537+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 8%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Andrew
1
Reputation point
commented 2020-09-04T16:29:28.28+00:00
Brenda Stewart
96
Reputation points
3 answers
One of the answers was accepted by the question author.
Tipping point Nested loop join and hash join ?
are there any tipping point for the query optimizer to choose between Nested loop join and hash join
1 answer
One of the answers was accepted by the question author.
Tipping point batch mode on row store : SQL Server 2019
what's Tipping point for choosing batch mode on row store : SQL Server 2019
3 answers
One of the answers was accepted by the question author.
SHOWPLAN_TEXT ON vs SHOWPLAN_ALL ON
what's the actual difference ? I can't see
3 answers
parallel plan slower than serial plan
Can anyone give an example that parallel plan (parallelism) slower than serial plan
2 answers
One of the answers was accepted by the question author.
Having issues with a function to change a parameter value.
I have 2 parameters coming in - one has a job number that has to be reformatted and updated to the other. I wrote a function to do the format because nothing I tried in the expression for the second parameter worked. Well, it's still not working. The…
asked 2020-09-03T20:49:18.04+00:00
Brenda Stewart
96
Reputation points
accepted 2020-09-04T15:09:19.373+00:00
Brenda Stewart
96
Reputation points
8 answers
One of the answers was accepted by the question author.
sql server windows ad role permisions
I would like to grant a specific windows role automatic permissions to be the "dbo" every time a new database is created, can this be accomplished using the model database, thanks
asked 2020-08-28T21:35:16.477+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NeophyteSQL
241
Reputation points
commented 2020-09-04T14:44:49.89+00:00
NeophyteSQL
241
Reputation points
2 answers
One of the answers was accepted by the question author.
SSRS - Color coding values based on data compare
Hi Folks: We have SSRS report (2016) with 2 columns Qty1 and Qty2 and want the record colored (red) If the Qty1 and Qty2 are matching. The Qty2 column has records in 5 decimal places and we want to round off to 3 decimal when comparing the values. I…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 67%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
9 answers
One of the answers was accepted by the question author.
Best way to create a second instance current and available 24x7.
Hi everyone! What would be the best solution to make a production database available to another SQL Server instance (on a different server) in read-only mode, without interruptions? I mean, current and available 24x7. Mirror, replication, etc. …
asked 2020-09-02T20:37:04.867+00:00
Doria
1,246
Reputation points
commented 2020-09-04T09:49:40.92+00:00
Erland Sommarskog
102.1K
Reputation points MVP
2 answers
SQL Server SSIS Package - IDE
Microsoft®VisualStudio Pro Sub MSDN version is good for SQL Server SSIS Package development
asked 2020-08-28T17:43:45.037+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 99%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Pandurangan, Balavenkatesh
1
Reputation point
commented 2020-09-04T09:48:47.423+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
2 answers
User Account receives primary key violation but not another user
Hi We're trying to set up a proxy user to run an SQL Server job, but there are steps in the SSIS package with are MERGE statements. The user account set up, which has sysadmin rights against the databases, receives a 'Violation of PRIMARY KEY…
asked 2020-08-28T00:42:41.373+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 14.000000000000002%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mia
1
Reputation point
commented 2020-09-04T09:40:53.747+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
SSIS in SQL Job
Hi, I have an SSIS package with an XML file, and it works correctly, but when I use it (the SSIS package) in SQL job I got an error about the path of the XSD file. How Can I handle it in the Config file or invariable in the SSIS package? I…
asked 2020-08-28T13:21:45.977+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2020-09-04T09:29:55.433+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Printing text query results to pdf fails
when attempting to print query results (to text) to a pdf it fails with error: Value cannot be null. Parameter name: moniker. What is the fix for this.
asked 2020-09-01T12:44:42.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 60%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Buzzy Cheadle
1
Reputation point
commented 2020-09-04T09:19:21.863+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
MEMORYBROKER_FOR_STEAL vs MEMORYBROKER_FOR_CACHE
what doesnt these two memory brokers do ?? MEMORYBROKER_FOR_STEAL <<< steal from buffer pool , but steal for what? what's the destination of this steal ?
asked 2020-08-28T18:26:45.973+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,321
Reputation points
commented 2020-09-04T09:00:57.563+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
Unable to start Azure Data Factory SSIS Integration Runtime for my Managed Instance
I'm trying to deploy an Azure Data Factory SSIS Integration runtime for use with my SQL Managed Instance (on the private interface). I keep running into the same issue with this error: Failed to start the integration runtime: SSISintegrationRuntime.…
asked 2020-08-31T11:05:08.297+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 4%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EJR
1
Reputation point
commented 2020-09-04T08:50:22.727+00:00
Monalv-MSFT
5,896
Reputation points
5 answers
One of the answers was accepted by the question author.
Search for a table name in all the stored precedures
Greeting all , i want to search for a table name in all my stored procedures( over 200 ) to add some filters in it . is there a way i can make a search on all my stored procedures to find which ones that contain the table name ? Thanks in…
asked 2020-09-03T16:13:53.363+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rami Frikha
91
Reputation points
accepted 2020-09-04T08:25:37.667+00:00
Rami Frikha
91
Reputation points
1 answer
One of the answers was accepted by the question author.
Tabular Error in project
Hi, I am currently working on a SSAS tabular model cube. I am getting the below error. Plz someone could help on this ? The size of a data value in table '<#####>' column '<******>' was too large to fit in that column. The current…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 48%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
How to fix "Infinity" and "Nan"
I am getting "Infinity" or a "NaN" value on my expression below. Suggestions on my expression to improve it? =Sum(CDbl(IIF(Fields!Type.Value = "Charges", Fields!PatientAmount.Value + Fields!InsuranceAmount.Value, 0)))…
asked 2020-08-29T16:22:25.683+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 8%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jeff S
1
Reputation point
commented 2020-09-04T06:52:14.15+00:00
ZoeHui-MSFT
33,386
Reputation points