SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,955 questions
3 answers
Can't be able to add node to a SQL server failover cluster
While adding a node to a Sql server failover cluster, I am getting error like this - Error: The credentials you provided for the Sql server agent service are invalid.
asked 2020-08-19T05:08:11.483+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(153.6, 28.999999999999996%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
AMRITANSHU AMRITANSHU
1
Reputation point
answered 2020-08-26T01:22:51.777+00:00
m
4,271
Reputation points
3 answers
How can two sql servers have different disk read time in same SAN?
I have two sql servers in same SAN. The servers host the databases added in alwayson group. One of the servers is responding well but the other server is responding slowly while running queries. When I look at the disk read time one server has below 1 ms…
asked 2020-08-19T03:36:12.88+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(227.2, 34%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Surendra Adhikari
211
Reputation points
answered 2020-08-26T01:22:24.447+00:00
m
4,271
Reputation points
2 answers
One of the answers was accepted by the question author.
Create a cursor that update field type char value in Sql Server
Hello , i want create a cursor that update column of my table Schools with more than three levels of education are level A, Schools with two levels of education are leveled with category B and other schools are leveled with category C. I tried…
asked 2020-08-25T00:51:44.173+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(83.2, 70%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
jonathas moura
21
Reputation points
commented 2020-08-25T22:07:37.11+00:00
Erland Sommarskog
102.6K
Reputation points
9 answers
sql server sa account disable
I am working on renaming and disabling the sa account the sa account has been renamed to sa_tmp the dbo user on all databases now show they are associated with the login sa_tmp if I disable the login, how should I handle all the schemas owned by…
asked 2020-08-25T00:48:10.26+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
answered 2020-08-25T22:04:09.327+00:00
Erland Sommarskog
102.6K
Reputation points
4 answers
One of the answers was accepted by the question author.
recovering space just eaten by my rollback
hi i'm sure i just consumed a lot of log space by rolling back the results of an in flight voluminous insert. my c: drive shows i'm down to bare bones. how can i recover that space before i move on? do i need to recover it, ie will sql blow it away…
![](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(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
adobe saves report incorrectly
Hi after some work, my subreport which is just one rectangle enclosing various "sub" rectangles etc looks beautiful when saved to word. But ridiculous when saved to pdf. the first sub rectangle prints on pg 2 out of order after the 2nd…
1 answer
One of the answers was accepted by the question author.
403 error from app requesting report rendering
hi i'm geting particulars on the calling app but a peer of mine trying to render my report from his app got the following error. i reached out to him to determine if he entered the ssrs report directory correctly but if the community can offer insight…
7 answers
One of the answers was accepted by the question author.
metadata issue
hi , i'll post the rest of the question once i see this new forum doesnt bounce me out
2 answers
One of the answers was accepted by the question author.
Delete command for Oracle table has warning : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
I have created an ssis package that processes data on sql server and loads results to an oracle table. I am using an execute sql task to delete existing records in the oracle table before reloading the table. The execute sql command has oracle…
asked 2020-08-24T22:55:22.4+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
accepted 2020-08-25T14:22:40.233+00:00
Anonymous
2 answers
One of the answers was accepted by the question author.
not able to put is equal to sign (=) in query,
When i am inserting is equal sign= in query code sample then sign (=) in query is not showing in preview, what can be the issue
asked 2020-08-22T09:21:16.07+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(12.8, 75%, 11%)' 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)
Analyst_SQL
3,551
Reputation points
accepted 2020-08-25T12:22:24.91+00:00
Analyst_SQL
3,551
Reputation points
2 answers
One of the answers was accepted by the question author.
Max degree of parallelism (MAXDOP) on SQL Failovered clustered instances.
We have 4 node SQL cluster. Each node has 4 physical processors with 18 cores each, 36 logical processors each. Cluster is running 23 instances, we are going to set "Cost Threshold of Parallelism" = some higher value (50). Currently this is set…
asked 2020-08-24T18:46:22.347+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(240, 95%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijay Kumar
161
Reputation points
accepted 2020-08-25T09:57:50.83+00:00
Vijay Kumar
161
Reputation points
1 answer
One of the answers was accepted by the question author.
Problems with calculation groups in Power BI connected to SSAS (tabular)
Hi guys, I'm trying to use calculation groups in Power BI that is connected to SSAS (tabular) but I'm having a few problems. First problem is processing the calculation group, I'm adding the items in Tabular Editor & VS19 and processing…
asked 2020-08-24T05:02:52.42+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(201.6, 1%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Cameron Wallace
31
Reputation points
accepted 2020-08-25T09:29:59.783+00:00
Cameron Wallace
31
Reputation points
4 answers
SQl server 2008R2 Performance issue after SP3 update
Hello, We have recently applied SP3 KB2979597 and Security Update Patch KB4057113 on Sql server 2008R2 but after that our couple stored procedures runs slow, it's taking almost 4 to 5 hours, but normally it was running under 5 minutes. Any one has…
asked 2020-08-19T16:39:31.49+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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
391
Reputation points
commented 2020-08-25T09:16:52.92+00:00
CathyJi-MSFT
21,101
Reputation points Microsoft Vendor
1 answer
SSRS 2016 allows the display of sensitive parameter in its URL such as Session state token
SSRS 2016 allows the display of sensitive parameter in its URL, such as Session state token. This can be used to manipulate the data being displayed allowing other resources information be visible to other users.
asked 2020-08-20T09:17:11.547+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(140.8, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Ismael González Briongos
1
Reputation point
commented 2020-08-25T08:58:36.64+00:00
ZoeHui-MSFT
33,946
Reputation points
1 answer
Vulnerable and outdated Jquery and bootstrap version (Integrity)
SSRS 2016 uses vulnerable Jquery 3.3.1 and Bootstrap 3.3.5. A security assessment found that an attacker may use the vulnerable JavaScript framework version to perform malicious attacks. Assessment suggestion for remediation is patching or update to…
asked 2020-08-20T07:38:43.74+00:00
Ismael González Briongos
1
Reputation point
commented 2020-08-25T08:58:17.857+00:00
ZoeHui-MSFT
33,946
Reputation points
1 answer
Help creating a Report that Combines output of 2 tables and a Query
I'm not sure if this is even possible but wondering if anyone has any advice to help see if? Current doing this in Report Builder 3 I'm hoping to have a report out put something kinda like the below The goal is based on two other tables and…
asked 2020-08-18T05:02:27.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(278.4, 57.99999999999999%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Joshua Reynolds
1
Reputation point
commented 2020-08-25T08:56:46.123+00:00
ZoeHui-MSFT
33,946
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL job (email) alert to warn of disk getting full
I am trying to create an alert from SQL server to send me an email when the log or data files for a database are almost about to fill up the disk they reside on. Is anyone able to help with this?
![](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(278.4, 21%, 36%)' 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)
3 answers
Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'CONVERT'.
I have this table that I'm trying to convert "2004-06-08 00:00:00.0000000" Datetime to just Date mm/dd/yyyy. Each row has a unique date. This is the code that I used below. This "Msg 156, Level 15, State 1, Line 3 Incorrect syntax near…
asked 2020-08-20T19:57:17.57+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, 86%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chris Slinko
1
Reputation point
commented 2020-08-25T07:41:00.803+00:00
CathyJi-MSFT
21,101
Reputation points Microsoft Vendor
4 answers
Performance Issues SSAS tabular Matrix drill downs
When i drill down in a powerbi report or when i run the extracted Dax query from dax studio i get massive performance hits for certain queries (takes 10-12 seconds). I have tested these queries using a clear cache query and also monitored the Server the…
asked 2020-08-19T09:16:56.347+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(236.8, 55.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Datacrunk
1
Reputation point
commented 2020-08-25T07:01:08.87+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(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,816
Reputation points
2 answers
Backup Report for all the Servers - Connectivity issue
Hi, We are collecting Backup Report report from all the servers using SSIS job and storing into Sql 2008R2 Server Database table. We have Full Backup nightly job which is running on the all servers and we are capturing these backup infor from all the…