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
Agent job having step type powershell-How to find spid?
Good morning Experts, We have a Agent job. It has a step of type powershell. The job is running from long time. I want to know the SPID of the job but am unable to find it. I am ...Unanswered | 5 Replies | 51 Views | Created by juniorkiran - 7 hours 15 minutes ago | Last reply by Erland Sommarskog - 2 hours 32 minutes ago -
0 Votes
What is the data modeling and explain? how to use that data modeling?
What is the data modeling and explain? how to use that data modeling?Unanswered | 2 Replies | 55 Views | Created by sakthi2511 - 7 hours 1 minutes ago | Last reply by Sarat (SS) - 4 hours 28 minutes ago -
0 Votes
lost orientation in sql server
my boss comes back today. my db get the error message error 1222. I'm almostly scared to death by my ...Unanswered | 4 Replies | 60 Views | Created by Cloud.Ma - 13 hours 42 minutes ago | Last reply by Erland Sommarskog - 9 hours 44 minutes ago -
0 Votes
Installing MS-SQL 2016 core based license for MS-SQL 2014 Std Edition
Hi Team, We have installed and will be using MS SQL Server 2014 in our production environment. When contacted Microsoft vendor for the ... -
2 Votes
shrink a database that is in read-only mode.
Good Morning Experts, Why is not possible to shrink a database that is in read-only mode. KiranAnswered | 5 Replies | 146 Views | Created by juniorkiran - Saturday, July 01, 2017 9:26 AM | Last reply by Erland Sommarskog - Saturday, July 01, 2017 6:51 PM -
0 Votes
sqlpackage Export on linux unable to connect to localhost
Hello, I'm trying to Export my local database to a bacpac file so that I can import it into Azure. Unfortunately, the Export command is not working for me. ... -
0 Votes
select count(*) and select count(column) which is faster?why?
select count(*) and select count(column) which is faster?why? my boss will go back firm next week. If I can't ...Proposed | 4 Replies | 146 Views | Created by Cloud.Ma - Friday, June 30, 2017 4:07 AM | Last reply by Erland Sommarskog - Friday, June 30, 2017 9:01 PM -
0 Votes
Microsoft SQL Server 2014 express advanced installation Error
I was Installing SQL server 2014 express advanced on my pc windows 20 enterprise ,64-bit operating system,x64-based processor with 4GB RAM and 2.4GHZ and an error that made me to abort the process so ...Answered | 2 Replies | 92 Views | Created by Eric Manwa - Friday, June 30, 2017 6:23 AM | Last reply by Lin Leng - Friday, June 30, 2017 8:25 AM -
0 Votes
Design Query in Editor
Hi, How can i write query using Design Query in Editor. I am beginner and how do i learn myself. For example, how to find Operating ...Proposed | 1 Replies | 86 Views | Created by boopathi subramaniam - Thursday, June 29, 2017 8:53 PM | Last reply by Erland Sommarskog - Thursday, June 29, 2017 9:21 PM -
4 Votes
TEMPDB & Model Database Dependence
Hi all I'm just looking to clear something up regarding SQL startup, TEMPDB and its dependence on the Model database I have a "non-default" TempDB - by ...Answered | 6 Replies | 2354 Views | Created by SQL24 - Monday, September 16, 2013 8:20 AM | Last reply by Ujjwal Patel - Thursday, June 29, 2017 4:58 AM -
0 Votes
How do I setup the firewall for external access to sql
I cannot make a Pc access an Sql database on a server. But the same server can be accessed from other Pc's and the Pc can access other servers. In ...Unanswered | 2 Replies | 101 Views | Created by DaPaul - Wednesday, June 28, 2017 2:51 PM | Last reply by Rick Byham, Microsoft - Wednesday, June 28, 2017 3:33 PM -
0 Votes
XML parsing
Dear Experts , I need to parse the below XML <Root> <Employees> ...Answered | 4 Replies | 96 Views | Created by Abhisek Mondal - Wednesday, June 28, 2017 8:33 AM | Last reply by Abhisek Mondal - Wednesday, June 28, 2017 9:13 AM -
3 Votes
Microsoft.SqlServer.BatchParserClient, Version=14.100.0.0
Greetings, Encountered this issue today and solution seems to be installing x64\SQLSysClrTypes.msi ...Answered | 4 Replies | 156 Views | Created by KissMyAsthma13 - Tuesday, June 27, 2017 9:54 AM | Last reply by KissMyAsthma13 - Wednesday, June 28, 2017 7:20 AM -
2 Votes
Moving master.mdf and mastlog from node1 to node2 (corrupt master db)
Hello everyone, A few weeks ago I build my first Always on cluster with 4 nodes. The master.mdf and log were located on the same disk as the data. I tried to ...Proposed | 7 Replies | 131 Views | Created by Ro_vi - Monday, June 26, 2017 2:45 PM | Last reply by Satish Kumar Gajula - Tuesday, June 27, 2017 10:50 AM -
0 Votes
Creating/connecting to web database in VB.NET and ASP.NET
Hello! I have created an app as well as an asp.net webpage. Both are supposed to connect to the same web database. I do not have a hosted webpage yet, I would like to make sure that ...Unanswered | 1 Replies | 110 Views | Created by ChrisP1980 - Monday, June 26, 2017 7:40 AM | Last reply by Lin Leng - Tuesday, June 27, 2017 8:44 AM -
0 Votes
wanted to do a side by side install of sql (2008R2 / 2016)
wanted to do a side by side install of sql (2008R2 / 2016) on a server with 4 databases running . the 2008r2 should not be effected by the "side by side " install, and ...Proposed | 3 Replies | 116 Views | Created by alphamegansw - Monday, June 26, 2017 3:43 AM | Last reply by Teige Gao - Tuesday, June 27, 2017 8:18 AM -
0 Votes
Setup error installing sql server2012 developer edition on windows 10
I have downloaded the file en_sql_server_2012_developer_edition_with_service_pack3_64_dvd_7286643 file. When I double click this file and run the setup.exe file from the install root folder, I am ...Unanswered | 2 Replies | 104 Views | Created by akoranteng - Monday, June 26, 2017 7:16 PM | Last reply by Uri Dimant - Tuesday, June 27, 2017 4:53 AM -
0 Votes
SQL - Select rows after reaching minimum value/threshold
Using Sql Server Mgmt Studio. My data set is as below. ID Days Value Threshold A 1 10 30 A 2 20 30 A 3 ...Proposed | 3 Replies | 112 Views | Created by Neil_Ak - Tuesday, June 27, 2017 1:28 AM | Last reply by Hilary Cotter - Tuesday, June 27, 2017 2:15 AM -
0 Votes
Sql Performance Counters and its threshold
Hi Team, Can you please share any usefull link or videos that explains What is each Sql performance counter(Processes, Memory, Data File I/0, Batchprocessing ...Unanswered | 2 Replies | 122 Views | Created by Anil kumarG - Monday, June 26, 2017 10:13 PM | Last reply by Teige Gao - Tuesday, June 27, 2017 2:07 AM -
0 Votes
Prior Business Day Formula Access 2010 Select Query
I have an Access database which has several pass-through queries to pull prior business days data from the company system. My problem is the date formula in the Select query I use to summarize the ...Proposed | 1 Replies | 119 Views | Created by Lorac1969 - Monday, June 26, 2017 3:31 PM | Last reply by Erland Sommarskog - Monday, June 26, 2017 9:59 PM - Items 1 to 20 of 19662 Next ›
No announcements
