Huge Latency in TempDB - Hi All, We are facing a huge latency in tempdb, what will be the reason??? Latency 1174 1174 1166 1173
Checking for duplicate clients before INSERT - I'm involved in developing a client based application, and I'm working through how to do a duplicate check prior to...
Access users can't use SQL 2016 (?) - I'm migrating several Access backends from SQL Server 2005 to SQL Server 2016. I have successfully gotten the ODBC connections...
Add column into an existing table and add values - I just created a backup table from an existing table (The existing table contain some values in 'Marital Status' column...
DatabaseIntegrity CheckDB Job - Hi, i am using the ola's script for checkDB integrity,its all working well and i set the job to send...
SQL user account lost its stored procedure execution access - Hi, SQL user account lost its stored procedure execution access . how to find what caused it to lose the access and...
SSRS - Inherited Server - Unable to find instance - Is it possible to repair? - Hello! On the SQL 2016 Server I am a "DBA" of now, I was looking to setting up SSRS. At first...
Apply targets to each month between two dates - I have a table in SQL which lists a monthly target for a particular contract (tblTarget). tblTarget has a layout like...
Sequential 'Alter Table' queries - Since my last visit, I've gotten by with just using my "Teach yourself SQL" book and lots of web searches. ...
Sort comma separated value in SQL Table - Hi I want to sort a column value alphabetically which is already in a sql table to something like below...
Need counts of orders per week grouped by week - Hello Everyone, I hope someone can help me out with this. I have an order table that stores order information.
Trigger insert - Hi, I have a table that keep track of the store procedures and it log errors. I want to add the...
SQL Server best practice.... - We recently created some new database servers (VMs), moving content to them from old servers approaching end of life. Our...
Stored proc with variables - Heloo, i have a problem with the follow storedproc in my VB program i have a lot of tables with SQL...
Logic to check for empty table before joining - Hi All, I have a requirement which requires me to display report as per the dimension access to the user trying to pull the...
Sending emails to customers in their language - Hi Everyone I was wondering if it's possible to send emails to customers in their native language? Our Server/DB is in us_english...
Show data based on MAX Action date - end of the month - Hi, I have the below query and like to show only the values highlighted in yellow in 2018-01-31. The previous months...
Cannot convert between unicode and non-unicode string data types - I am working on an SSIS project, to pull data from Oracle 10.2g into SQL Server 2008R2, 64-bit. This project...
Moving zip files - Hi guys This sounds like it should be simple but I'm banging my head on the brick wall again. I have an...
Package variables reference environment variables? - I have a package where network file paths are set up as package parameters, and these parameters are referenced in...