sql-server-2012's questions - Chinese 1answer

3.963 sql-server-2012 questions.

We have 2 node onsite and the 3rd node on DR and there is no disk witness. Due to maintenance I set the Dr site to be primary and the other 2 nodes to be manual in asynchronous mode and after both ...

Query execution plan does not show the locking details by default, is it possible to view the locks, along with the type, acquired during the execution of a query?

We are running SQL Server 2012 on Windows 2008 R2 with 256GB RAM and 90% memory allocated to SQL Server. No other Apps run on the server. I have a scenario where I’ve to copy a Source (staging) table ...

I'm trying to create a ReportServer database on a different server (Server_AT) other that my Reporting Service server (Server_RT). ON Server_AT, I created the RSExecRole as per the script here. Then ...

As I would like to say that we are going to downgrade the SQL Server Standard 2012 SP1 edition with SQL Server Express 2012 SP1 in one Production Server. For the time being I want to keep the SQL ...

Programming stored procedures isn't my strongest point when it comes to programming, but I'm trying to get better. I've stumbled upon a business requirement that's kind of hard for me and I was ...

One person can have many human friends (many to many) - Shoaib has three friends (ydk,nabeel, adnan) - Adnan has four friends ( ydk,shoaib, shahbaz,Imran) - Shahbaz has three friends (adnan, qaisar,...

As I would like to say that by mistake the SQL Server 2012 backup file (.bak) open with wordpad. Due to this reason all backup files of SQL Server (.bak) file change with wordpad icon in entire the ...

I have an SQL statement that is taking about 40 seconds to run and the only thing I see is an high hash match and sort. I have added indexs to the temp table but still taking an long time to complete. ...

We have this one user who uses SSMS to connect to a 3 node 2 instance fail over cluster. He also uses SSIS, Excel, SharePoint, SSAS etc.. to connect to this database instance I'll call TEST. There are ...

I have done extensive research on querying LDAP Server but so far has not been able to work around. Therefore, asking experts help Background: I have a client whose LDAP Server is OnPremise (though ...

I would like to set up a "reading" user on my SQL Server 2012 instance. I would like to allow him the right to execute any stored procedure, or function, or direct SQL statement, which retrieves data ...

I am attempting to write a query that will be consumed by a SSRS 2012 report. Given a paid invoice, with a certain set of account allocations towards which the money paid towards it must be saved, I ...

I have three tables (SalesTable, StoresTable and ProductsTable) and the structure is the following: --StoresTable StoreId Name 1 Store 1 2 Store 2 --ProductsTable Id Description 1 ...

can anyone fix my problem ? i wanted to return the value "SERIAL EXISTING" but i can't make it happen. i already doing it overnight. CREATE PROCEDURE ADDHARDWARE @serial varchar(100), @location ...

I have recently set up SSDT for our developers to use. We enforce changes to our dev databases are made through SSDT by limiting the permissions that each developers has when connected to the server (...

My knowledge with triggers is very poor. I want to create an INSERT/UPDATE/DELETE trigger on a tableA with column names (A1,A2,A3,A4,A5,A6). After the triggers fires, I want to put that data in ...

I have very complicated situation here. Application team was reporting that they see spikes and errors every 20 mins. We checked what was running and found log backups. So we tuned log backups using ...

I just setup SQL Server 2012 (on Windows Server 2012) Always On feature and have a problem with connecting to SQL Server Listener from non-primary node (it works from primary node though). Here is ...

I have a stored procedure that basically selects values from one table and inserts them to another, a sort of archiving. I want to avoid multiple people from doing that at the same time. While this ...

we are working on a project to implement a large ERP system. We found out that one of the tables has a synonym to another database. Both databases are in the same instance. Our project leader has ...

I have now: SELECT TABLE_SCHEMA , TABLE_NAME , COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'NNN'; This gives me several hundreds of rows, because several tables contain ...

I wanted to understand what my options to improve select statement on table with 25M rows. Because I am using date is table partition an option? SET STATISTICS TIME ON SET STATISTICS IO ON SELECT ...

I have a two node SQL 2012 AlwaysOn HADR cluster (v11.0.3412) with 3 availability groups configured. The AG groups are set to synchronous mode and the secondary is not readable (we do not want the ...

I am observing that the backup and index maintenance (Ola's) jobs are taking almost 4 times the time it used to take after moving from a physical to a virtual. I am trying to see if CPU speeds affect ...

We have a stored procedure that we run regularly. It blows up the size of TempLog.ldf from nothing to 150 GB in the course of 3-4 hours. What's going on and why is it so big? TempDB.mdf is a constant ...

Monitoring software has indicated average lock wait times rising to 500ms during the night. Is there any way of confirming which locks these were as we currently do not log any performance data to a ...

I have a Microsoft SQL Server 2012 database table with around 7 million crowd-sourced records, primarily containing a string name value with some related details. For nearly every record it seems ...

I have a table with below mentioned structure create table #test ( ID int identity(1,1), A int, B int ); and having data as ID A B 1 9 NULL 2 9 1 3 9 2 4 8 NULL 5 8 4 6 8 ...

We replaced a physical server with virtual, I copied all the logins, and linked servers from the old server and restored all the databases from the old server to the new. Everything works fine except ...

I run this Script: SELECT dest.TEXT AS [Query], deqs.execution_count [Count], deqs.last_execution_time AS [Time], (select case when dest.TEXT like '%select%' ...

How do I copy the structure and contents of the tables below in SQL Server Management Studio from database SNO_TEST to SNO_TMP (on the same server)? The names of the tables are ADMIN_ErrorLog, ...

First question on this SA but I feel my problem is more Database related than code related. I have multiple Delphi Datasnap servers connecting to SQL Server 2012. The SQL server has multiple ...

Two servers: sq009 and sq202, both running SQL Server 2012 SP3. sq202 is the SQL Server hosting the DB for our ERP system, Sage 500. sq009 is the SQL Server hosting the DB for our IBM Maximo instance....

I have a database and want to move the .mdf and .ldf files to another location. But I do not want to stop the MSSQLSERVER service, and I do not want to export to another server. How can I do this?

Is there a way to do a full-text search using words stored in another table? This is my scenario: Table_A contains phrases entered by users in field "UserInput" (and other stuff). I have a full-...

We are using LS for reporting purpose. LS backup runs on primary every 15 minutes. On Secondary nightly restore via LS restore job is done daily at 10 PM. While the nightly restore job is running, ...

I recently had to recover my ssisdb databases, along with all other user databases to a new server because of a hardware failure. I am now seeing the following errors when trying to run ssis jobs ...

I have an OrgChart table that looks something like this: PositionCode PositionName ParentCode Level AA0001 CEO 0 AA0002 CFO AA0001 1 AA0003 ...

When using sp_send_dbmail to send an email on SQL Server, how do you specify that the email be sent in an encrypted format? I found a thread discussing including the string "[SECURE]" in the subject ...

A few months ago I added an extended event to track blocked processes and deadlocks, with a file output to track occurrences. Every now and again, I check the log file, but find that the extended ...

We have an Always On availability group with a primary and a read-enabled secondary. We have a user for the implementation team who uses the database to check the correctness of the data that they are ...

I am from SQL Server background and recently getting my hands dirty with Oracle 12c. I came across few features of Oracle called multi-tenant, Container Database and Pluggbale database. Can somebody ...

I have a maintenance plan set up on our SQL Server 2012 that contains only a "History Cleanup Task", which is configured to delete the following data if older than 4 weeks: Backup and restore history ...

PS C:\Windows\system32> get-cluster Name ---- sql2012poc_cl1 PS C:\Windows\system32> get-clustergroup Name OwnerNode State ----...

I want to set permission against a user, which can create database and drop on their created databases neither any database. Any idea/suggestion ?

If a system allows users to save draft (not versioning but kind of like partial save) of their work in database, I can think of 3 ways. I see similar questions being asked here already but I could ...

I want to use a parameter within where clause only if it's value is provided by strongly typed dataset, this is what I am trying at the moment, I get right results when I provide parameter3 and no ...

Following a restart of a SQL Server 2012 SP3 instance caused by a reboot of the unresponsive host WINTEL server, I have a SQL Agent Log Shipping Copy job (which uses a proxy account to access the NAS ...

I have two instances on the same server; one is for TEST and another is for DEV. TEST Total Database Size: 350 GB Memory allocated: 30 GB DEV Total Database Size: 350 GB Memory allocated: 20 GB ...

Related tags

Hot questions

Language

Popular Tags