No announcements
-
0 VotesPOSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you want to show us what you see on ...
-
0 Votes
how to calculate percentage using count from 1 single bit type column
I have a table named attendance that has a column named Pre for marking Present as True and Absent as False. i am using same column for marking both absent or present now the issue ...Unanswered | 6 Replies | 232 Views | Created by Jazz17 - Sunday, June 16, 2019 7:18 PM | Last reply by Jazz17 - 52 minutes ago -
0 Votes
AG question
Is there a way/documentation to identify how long will a transaction take to commit on secondary for asynchronous Always on? Or is totally dependent on network speed?Unanswered | 4 Replies | 100 Views | Created by sqldba_24 - Monday, June 17, 2019 3:17 AM | Last reply by Cathy Ji - 2 hours 21 minutes ago -
0 Votes
Tempdb issue
Good Morning Experts, We had a tempdb issue today. Tempdb was missing from its original location. My colleague copied tempdb files from another server to this server and issue got ...Proposed | 3 Replies | 54 Views | Created by juniorkiran - 15 hours 37 minutes ago | Last reply by Cathy Ji - 3 hours 5 minutes ago -
0 Votes
How to delete a SQL Server local security group on Windows 10 Home?
Administrative Tools > Computer Management > Local Users and Groups'. Because I have Home edition, the 'Local Users and Groups' option does not seem to be available so I cannot delete ...Proposed | 7 Replies | 198 Views | Created by fhurtado - Sunday, June 16, 2019 8:23 AM | Last reply by fhurtado - 8 hours 9 minutes ago -
0 Votes
disk latency
I am using SS 2008 R2 EE and most user dbs are using compatibility of 80 (ss2k). The server hasnt been rebooted since an year and we are noticing slowness over the past few days. I am using a ...Unanswered | 6 Replies | 207 Views | Created by sqldba_24 - Wednesday, June 12, 2019 11:51 PM | Last reply by Shanky_621 - 11 hours 49 minutes ago -
0 Votes
Automatically save output as Tab Delimited Textfile
Apologies if this is too simple - I am something of a noob at SQL! I'm using SQL SM Studio 17 I have a query that runs in 3 parts SELECT ...Unanswered | 3 Replies | 77 Views | Created by GaryB 63 - 16 hours 27 minutes ago | Last reply by GaryB 63 - 14 hours 55 minutes ago -
74 Votes
MS SQL Management studio 18 not starting
I have installed latest SMSS (Downloaded May 5th, 2019). It worked for 3 days, and then when I try to start it, it just closed with windows sound error, but no message on any of my ...Answered | 34 Replies | 8495 Views | Created by Анѓелкоски Методија - Tuesday, May 14, 2019 7:09 AM | Last reply by JasonYork - 16 hours 24 minutes ago -
3 Votes
Jobs not executing through scheduler
I am running db (SQL Server 2016) backs using a simple SP, which works fine when run from ssms 2017. However it errors out from sql server agent job. It says "server principal ...Proposed | 6 Replies | 99 Views | Created by Neilcse - 22 hours 23 minutes ago | Last reply by TiborK - 18 hours 8 minutes ago -
0 Votes
Error removing instance of Microsoft SQL Server 2017 instance trought removing tool
C:\Windows\Installer\1cae33.msi MSI (s) (0C:3C) [11:16:43:866]: Package we're running from ==> C:\Windows\Installer\1cae33.msi MSI (s) (0C:3C) [11:16:43:867]: ...Unanswered | 2 Replies | 119 Views | Created by Hessuew - Friday, June 14, 2019 8:20 AM | Last reply by Dedmon Dai - 21 hours 3 minutes ago -
5 Votes
How to install sql server 2008 R2 on Windows server 2016
Dear Ms Tech, I have just buy new Server. I buy new license windows server 2016. I deploy install windows server 2016 My system is stable in MS SQL server 2008R2. ...Answered | 7 Replies | 13715 Views | Created by Phuong, Nguyen Van - Saturday, February 25, 2017 4:36 PM | Last reply by Phuong, Nguyen Van - 21 hours 41 minutes ago -
0 Votes
Restore getting failed after 40 percent completes
Hi all, I have issues while restoring a 1 TB of database. It started smoothly but once it reaches 40 percent restore getting failed. Again i started to backup ...Unanswered | 7 Replies | 221 Views | Created by Arunachalam C - Tuesday, June 11, 2019 3:07 PM | Last reply by Dedmon Dai - 22 hours 32 minutes ago -
1 Votes
A few questions about database concepts
Hello 1. Is the table name an entity? (for example "Employees Table" ) 2. Is the column name an entity? (CustomerID, ...Answered | 1 Replies | 128 Views | Created by rpone - Sunday, June 16, 2019 5:50 PM | Last reply by Erland Sommarskog - Sunday, June 16, 2019 7:50 PM -
18 Votes
What's the difference between installing a "Default Instance" vs a "Named Instance"?
What's the difference between installing a "Default Instance" vs a "Named Instance"? How do I make decision on which to do? Thanks. System configuration: Winndows 7 RTM, ...Answered | 9 Replies | 85447 Views | Created by BradleyA - Monday, October 26, 2009 10:11 AM | Last reply by Leonel Chamanhonga - Saturday, June 15, 2019 12:43 PM -
0 Votes
SQL 2019 CTP - Polybase External Table for Cloudera HDFS
Hi, I'm trying to create an external table in sql 2019 for Cloudera HDFS by using the following code: -- IDENTITY: the Kerberos user name. -- SECRET: the Kerberos ...Unanswered | 3 Replies | 272 Views | Created by guillaume kieffer - Wednesday, June 5, 2019 12:40 PM | Last reply by Dedmon Dai - Friday, June 14, 2019 10:05 AM -
0 Votes
Difference between SQL Server Cluster name and SQL Server Instance name
Can anyone please guide me as in when 2 SQL Servers are clustered then what will be the cluster server name and what will be the cluster instance name? For one of my client they have only ...Answered | 3 Replies | 169 Views | Created by Ekta Sri - Thursday, June 13, 2019 2:06 PM | Last reply by Cathy Ji - Friday, June 14, 2019 9:03 AM -
0 Votes
When creating a SQL AG can we use the primary node (active) when the nodes are being added to the availability group?
When creating a SQL AG can we use the primary node (active) when the nodes are being added to the availability group? We have a very large database (10 TB) which we would like to ...Answered | 3 Replies | 321 Views | Created by kimdav111 - Wednesday, June 12, 2019 10:24 PM | Last reply by Cathy Ji - Friday, June 14, 2019 5:31 AM -
0 Votes
Install SQL server in a domain environment authentication
I am about to install SQL server on one of our servers within a domain environment i will be using mixed mode for authentication during the installation, i was ...Unanswered | 3 Replies | 164 Views | Created by Tornado23 - Thursday, June 13, 2019 4:26 AM | Last reply by Dedmon Dai - Friday, June 14, 2019 3:25 AM -
0 Votes
SQL Server & Shadow copies
Hello, I have a question... Is it ok to have shadow copies on all drives on the SQL Server? Can be there any problem if we are not talking about performance? ...Answered | 4 Replies | 2358 Views | Created by d3vl1n - Thursday, March 5, 2015 9:21 AM | Last reply by Richard Long - richard2long4u269 - Thursday, June 13, 2019 11:50 PM -
0 Votes
Does Azure SQL IaaS using Azure backups (on the IaaS blade) save automatically to a vault?
Does Azure SQL IaaS using Azure backups (on the IaaS blade) save automatically to a vault? We do not want to create a DPM server or another backup server. Does a MARS ...Unanswered | 3 Replies | 193 Views | Created by kimdav111 - Wednesday, June 12, 2019 7:48 PM | Last reply by kimdav111 - Thursday, June 13, 2019 7:49 PM -
0 Votes
Cannot start SQL Server Agent service (MSSQLSERVER), help me!
YYYY-MM-DD xx:xx:xx - ? [100] Microsoft SQLServerAgent version 13.0.4001.0 (X64 unicode retail build) : Process ID 11484 YYYY-MM-DD xx:xx:xx - ? [495] The SQL Server Agent startup ...Proposed | 6 Replies | 235 Views | Created by Vu Nguyen Truong - Thursday, June 13, 2019 3:02 AM | Last reply by Cathy Ji - Thursday, June 13, 2019 8:51 AM - Items 1 to 20 of 21296 Next ›
No announcements
