No announcements
-
0 VotesRestoring the Database mdb.bak file
Hi, I am restoring the mdb.bak file from MS SQL 2012 server named 'ITASM' to MS SQL 2016 server named 'ibntest002063'. But While restoring the file I am ...Answered | 16 Replies | 143 Views | Created by du00805 - Monday, October 7, 2019 12:44 PM | Last reply by TiborK - 39 minutes ago
-
0 Votes
setting up 3rd party job scheduling userids that can execute sp start job
powershell (via script file) -> exec sp start job -> sql agent-> ssis catalog. Beside the permission the userid will have on the file system where the ...Unanswered | 5 Replies | 145 Views | Created by db042190 - Friday, October 4, 2019 6:55 PM | Last reply by db042190 - 2 hours 7 minutes ago -
0 Votes
Determining the size of Buffer Pool
Hello! I'm trying to figure out the size of SQL Server memory buffer pool on my server - this can be done by 1) using the sys.dm_os_buffer_descriptors view or 2) the ... -
0 Votes
Connecting a local AD Client App to a hosted Azure SQL database using Azure AD.
Background. I have a client that wants to move the database that they connect to from their local network to their Azure cloud server. They have purchased a few companies and they will not be ...Unanswered | 1 Replies | 47 Views | Created by Notice-Tax - 22 hours 16 minutes ago | Last reply by Dedmon Dai - 7 hours 29 minutes ago -
1 Votes
Waiting queries
Do waiting queries increase CPU load ? How to reduce wait time of waiting queries ?Unanswered | 20 Replies | 397 Views | Created by Curendra - Saturday, October 5, 2019 3:21 PM | Last reply by Erland Sommarskog - 17 hours 0 minutes ago -
0 Votes
is WITH(READPAST) affected by readlocks
If a transaction calls a SELECT using the table hint WITH(READPAST)... will it skip rows that are locked by other SELECT statements that are in READ COMMITTED mode and are issuing shared ...Answered | 4 Replies | 7193 Views | Created by Josh Ashwood - Friday, March 18, 2011 4:32 AM | Last reply by Sam Bendayan - 19 hours 45 minutes ago -
0 Votes
estimating how much my tran log can handle on one transaction
Hi we run 2017 std. where I used to work we had a dashboard that would not only show the available space in the tran log but also how much and how fast it was filling up when we were monitoring the ...Unanswered | 3 Replies | 143 Views | Created by db042190 - Friday, October 4, 2019 5:17 PM | Last reply by db042190 - 23 hours 53 minutes ago -
0 Votes
Identity Columns Randomly Regress to a Lower Value
Hello, We have an in-house developed database application that uses SQL Server 2016 (13.0.5101.9) for backend data storage. Numerous tables have identity columns ...Proposed | 10 Replies | 193 Views | Created by Dale Magnant - Friday, October 4, 2019 1:18 PM | Last reply by Dale Magnant - Monday, October 7, 2019 1:36 PM -
0 Votes
sp_send_dbmail sends *.csv.txt instead of *.csv
The following code sends files with the extension *.csv.txt. Is there a way to send it as *.csv? The query is executed on Microsoft SQL Server 2012 - 11.0.7462.6 ...Proposed | 4 Replies | 85 Views | Created by Hotbuk - Monday, October 7, 2019 9:05 AM | Last reply by Tom Phillips - Monday, October 7, 2019 1:06 PM -
0 Votes
Migrate SQL 2017
currently we are in sql 2016, (windows Server) shall we migrate to SQL 2017? is this SQL 2017 provides more stability and ...Unanswered | 4 Replies | 147 Views | Created by KIRUBAKARAN J A - Sunday, October 6, 2019 2:43 PM | Last reply by Jefferson Silva DBA - Monday, October 7, 2019 2:59 AM -
0 Votes
Use SQL Graph table in PowerBI - SQL Server 2019 RC1
Hi, I'm trying to do build a dashboard in Power BI to visualize graph data stored in SQL Server graph tables. If I directly import the graph table Power BI will give an ...Unanswered | 1 Replies | 150 Views | Created by jyao75 - Friday, October 4, 2019 10:32 PM | Last reply by Cathy Ji - Monday, October 7, 2019 2:50 AM -
0 Votes
MDF & LDF file got deleted when ctll C and ctrl V. Not able to recover
MDF & LDF file got deleted when ctll C and ctrl V. Not able to recoverUnanswered | 7 Replies | 211 Views | Created by NRKandasamy - Friday, October 4, 2019 5:18 PM | Last reply by Sabrina Zhang - Monday, October 7, 2019 1:17 AM -
1 Votes
error while adding db back to Always on
Hi, we configured alwayson with 15 dbs in sql 2014. we configured full,diff and log backups. due to some reason the yesterday all log backups failed. due to this ...Answered | 5 Replies | 235 Views | Created by joo123 - Saturday, October 5, 2019 2:53 PM | Last reply by joo123 - Sunday, October 6, 2019 4:18 AM -
3 Votes
Question on Heaps rebuild's
ALTER TABLE HeapTbl REBUILD; There is a HEAP table which has 88% fragmentation and it is around ~25GB. The table also contains LOB datatypes columns as well. ...Answered | 4 Replies | 222 Views | Created by Samantha v - Saturday, October 5, 2019 8:14 AM | Last reply by SQLZealots - Sunday, October 6, 2019 3:29 AM -
4 Votes
Timeout error while creating an index on heap
Hi Experts, While trying to create a clustered idx on a HEAP Table, we are seeing below error. How to avoid this error. This Table is originally a HEAP and now ...Answered | 4 Replies | 175 Views | Created by Samantha v - Saturday, October 5, 2019 8:25 AM | Last reply by Erland Sommarskog - Saturday, October 5, 2019 12:53 PM -
0 Votes
Change uppercase characters to lowercase in database name - AlwaysON
think i know the answer already but will ask anyway.. At customer site and they have a database with a mix of uppercase and lowercase characters in the database ...Answered | 16 Replies | 253 Views | Created by ilikefondue - Wednesday, October 2, 2019 2:33 PM | Last reply by ilikefondue - Friday, October 4, 2019 3:01 PM -
0 Votes
SQL Server 2014 SP3 CU4 and Security Update KB4505422
Hello We have latest CU4 installed for SQL Server 2014 SP3, but Vulnerability scan engine warns about missing security ...Answered | 9 Replies | 230 Views | Created by Yeghishe - Wednesday, October 2, 2019 4:43 PM | Last reply by Yeghishe - Friday, October 4, 2019 1:17 PM -
0 Votes
DBCC CheckDB on tempdb
Does Microsoft advise to run DBCC CHECKDB on tempdb? If not and if it is advisable, WHY should I perform that and what is the impact of corruption in tempdb on data in other databases? These are ...Unanswered | 6 Replies | 245 Views | Created by Niels Br - Monday, September 30, 2019 6:32 AM | Last reply by Niels Br - Friday, October 4, 2019 12:11 PM -
3 Votes
SQL Server Memory related question
Hi All, We have a QA environment where we have bunch of databases(18+) but with limitied RAM. After having some disussions with Application ...Answered | 4 Replies | 201 Views | Created by Samantha v - Tuesday, October 1, 2019 9:48 AM | Last reply by Samantha v - Friday, October 4, 2019 6:49 AM -
0 Votes
How to get Schedule History and not Job History?
Hi all, I am building a report to show the Job all Scheduled details and Last Run Date time as well as Status. When I go to msdb.dbo.sysjobhistory I can find ...Proposed | 4 Replies | 298 Views | Created by Shivendoo Kumar Dubey - Monday, September 30, 2019 11:25 PM | Last reply by Dedmon Dai - Friday, October 4, 2019 1:01 AM - Items 1 to 20 of 34859 Next ›
No announcements
