Safe way to remove uniqueidentifier which is a primary key (clustered index) on a large 300 GB table in SQL Azure DB
Dear All, I have this table on an Azure SQL DB (S4 compute tier) which is 300 GB in size. On checking, I saw that the primary key is on an uniqueidetifier ID column. The fragmentation is over 99% as expected. As we know, it is not recommended to…
I am having a problem with Visual Studio not saving a password when I create a connection in SSIS connection manager.
I am having a problem with Visual Studio not saving a password when I create a connection in SSIS connection manager. I would like assistance with someone that is an expert in Visual Studio. Steps to recreate the problem. Open visual studio 2019. …
Access to Read-only Database to a non-SA user
Is there a way to allow a user (non-SA) access a read-only DB without setting the DB to read-write? Thanks.
windows系统中如何关闭52.139.168.125的数据包发送
windows系统自动不定期向52.139.168.125发送数据包,经过观察似乎是因为sqlceip.exe的运行而产生,请问sqlceip.exe是一个怎么样的程序,有没有关闭sqlceip.exe程序的方法,以及关闭该程序会否对系统产生不良影响。 谢谢。
Query SQL Error Log with T-SQL
Hi Team, I am treying to query SQL error log using T-sql. There is some issue with T-SQL. I am not getting error logs from last 24 hrs. CREATE TABLE #ErrorLogInfo ( ID INT…
Sql server 2014 developer edition setup error
Am trying to install the Sql server 2014 developer edition on Azure virtual Machine at the end of the installation process i have got an error like 1.Reporting services,Database Engine services,Full-Text semantic extraction for search has failed to…
Why can't I use the Import Data Wizard (on SSMS) to alter the default schema for new destination tables?
Hello, I hope this question is clear. I am still in the process of adding an image of the error message. I am using the wizard to import a flat file source into my database. I have SQL Server Express 2019. My goal is to create a table with…
Unable to see the "maintenance plan" option on sql 2008 express server to setup the backup schedules. logged in as admin
Hi Team, I have logged in as admin on the on-prem SQL server 2008 express edition but unable to see the "maintenance plan" option under "management" to schedule the backups to Azure storage account container. We have the SQL server…
Can I uninstall the MS SQL 2008 installation support files?
Hello everyone. We have a server (Windows Server 2016) with SQL Server 2016 Standard, but during installation of SQL 2016 also installed MS SQL 2008 Setup Support Files. The company need to uninstall MS SQL 2008 Setup Support Files, can I do it? Is…
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.
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…
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…
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…
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…
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…
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…
metadata issue
hi , i'll post the rest of the question once i see this new forum doesnt bounce me out
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…
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
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…