No announcements
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Sticky33Votes
!!! Internal MSSQL product teams, employees & MVPs blogs list !!!
Microsoft SQL Server Team Blogs List: · SQL Server Front End Team blog (SSMS, SMO, SQLAgent, Data Collector, ...24 Replies | 38662 Views | Created by Dannol Liu - MSFT - Thursday, September 04, 2008 2:43 AM | Last reply by Kumar Vivek - Thursday, March 14, 2013 12:43 PM
-
Unanswered0Votes
instance in database
what is instance in database?3 Replies | 50 Views | Created by bhagee - 2 hours 17 minutes ago | Last reply by Sanil Mhatre - 28 minutes ago -
Proposed0Votes
DMV statement and how to react upon the information
I am not sure how to use this information pulled through the query below SELECT * FROM sys.dm_os_wait_stats ORDER BY wait_time_ms ...7 Replies | 104 Views | Created by '''HuuM''' - Tuesday, August 20, 2013 6:56 PM | Last reply by '''HuuM''' - 40 minutes ago -
Answered0Votes
Instance or database
I need advise for following situation: i have my intranet consisting of a module for customers, which is accessed by all divisions of my company. now a new module named finance ...5 Replies | 3340 Views | Created by minyminks - Wednesday, December 09, 2009 6:10 AM | Last reply by bhagee - 1 hour 45 minutes ago -
Unanswered1Votes
How to enable logging and alerts related to deadlock
Hi, I am looking for a T- SQL script for enabling logging and alerts related to deadlock .And after running the script do we have to restart the SQL ...6 Replies | 49 Views | Created by BomaSri - 4 hours 34 minutes ago | Last reply by Shanky_621 - 1 hour 52 minutes ago -
Unanswered0Votes
instance in database
2 Replies | 37 Views | Created by bhagee - 2 hours 21 minutes ago | Last reply by karimSP - 2 hours 14 minutes ago -
Answered0Votes
Send email in a tabular format using SQL Server database mail conditionally depending upon result row count
Hi Experts.. Requirement: --If the following query resulted greater than ...5 Replies | 69 Views | Created by SQListic - 21 hours 17 minutes ago | Last reply by SQListic - 2 hours 51 minutes ago -
Unanswered0Votes
Deleted table in SQL Mgmt Studio, Trying to create a new table with same name, error: Table already exists
Deleted table in SQL Mgmt Studio, SQL 2008 Trying to create a new table with same name in the Mgmt studio when I click save and give it the name, i get ...1 Replies | 37 Views | Created by A Humaniod - 4 hours 43 minutes ago | Last reply by rksqldba - 3 hours 4 minutes ago -
Answered0Votes
error on views containing union
Here is my script: select * from view_tablea where patient_id is not null union all select * from view_tableb where patient_id is not ...2 Replies | 138 Views | Created by Sally Lue - Monday, August 12, 2013 10:15 PM | Last reply by Sally Lue - 3 hours 13 minutes ago -
Answered2Votes
Why Unique Index cannot be Created on a View which contains Union All operator
Hello all, I would like to know why we cannot create unique (clustered/non clustered )index on view which uses Union All operator in its definition. Thanks & ...6 Replies | 2768 Views | Created by Sambasiva Reddy - Monday, March 19, 2012 5:10 AM | Last reply by troff - 4 hours 55 minutes ago -
Answered0Votes
How do I save a “Count” SQL(server management studio 2008R2) query?
How do I save a “Count” SQL query? First “Count” query; SELECT ...4 Replies | 47 Views | Created by Raka-RSA - 6 hours 39 minutes ago | Last reply by Raka-RSA - 5 hours 12 minutes ago -
Proposed0Votes
DB slow even after adding lot of RAM
I have a database with about 300 GIg of data and approx 45 users the ram size is 68Gig for sql, in a first week of ...9 Replies | 136 Views | Created by '''HuuM''' - Tuesday, August 20, 2013 5:20 PM | Last reply by Tom Phillips - 6 hours 18 minutes ago -
Answered0Votes
help with simple CASe statement
7) ELSE ((DateDiff(m,AutoStatementLastDate, getdate()) > 0 AND Day(getdate()) > Day(AutoStatementLastDate)) END) Anyone help me get to the bottom of this please?3 Replies | 41 Views | Created by mtm81 - 7 hours 32 minutes ago | Last reply by mtm81 - 7 hours 4 minutes ago -
Unanswered0Votes
sql server connection
how to connect sql server and wheter sql is inbuilt with vs 2012 or we have to install separatly..... !!2 Replies | 43 Views | Created by vamshi1251 - 11 hours 53 minutes ago | Last reply by Srivastava Vishal - 7 hours 20 minutes ago -
Answered1Votes
SSMS - Re-open queries after a reboot?
Hi, Is there a setting somewhere in SSMS (Sql 2012) that will reopen queries after a reboot? I know that I can browse to the temp folder and open them ...6 Replies | 1159 Views | Created by The real Slartibartfast - Monday, November 05, 2012 8:06 AM | Last reply by AndreiRantsevich - 8 hours 44 minutes ago -
Answered0Votes
How to get date only ?
Hi All, How to get date only without time ? Here is my query select p.company,p.ponum as orderNum, p.orderdate,v.name as supplier,p.shipcountry as country, ...4 Replies | 65 Views | Created by Sam Daniel - 11 hours 47 minutes ago | Last reply by Sam Daniel - 8 hours 55 minutes ago -
Unanswered0Votes
SQL 2012 Enterprise (Evaluation) -> To Enterprise Core (Licensed) Edition Upgrade Warning on Always-On
Hi all, I am need to do an Edition Upgrade on a SQL Server 2012 Enterprise (evaluation) to a licensed version of the Enterprise version. We do already have set-up Always on ...2 Replies | 156 Views | Created by Hans van der Heijden - Monday, August 19, 2013 6:27 AM | Last reply by Samuel Lester - MSFT - 10 hours 47 minutes ago -
Unanswered0Votes
SqlBulkCopy retain multiple row in cell
= 13 Then bulkCopy.WriteToServer(objDR) ExcelConnection.Close() SQLconn.Close() End If End Using1 Replies | 96 Views | Created by annuz - Tuesday, August 20, 2013 5:10 AM | Last reply by Candy_Zhou - 12 hours 20 minutes ago -
Proposed0Votes
Service pack
Hi, What is service pack. Difference between patch and service pack? And also what is hot fix?2 Replies | 77 Views | Created by Surya.chamala - Tuesday, August 20, 2013 6:02 PM | Last reply by Samuel Lester - MSFT - Tuesday, August 20, 2013 7:32 PM -
Proposed0Votes
cummulative updates
Hi, what is cummulative updates, how often we will get, how to apply them?1 Replies | 76 Views | Created by Surya.chamala - Tuesday, August 20, 2013 5:57 PM | Last reply by Samuel Lester - MSFT - Tuesday, August 20, 2013 7:13 PM -
Answered1Votes
adding new column to the table that is already replicated
i have a script that is going to add new column in a table that has millions of rows. if not exists (select * from syscolumns where id=object_id('progressnote') ...5 Replies | 94 Views | Created by '''HuuM''' - Tuesday, August 20, 2013 3:53 PM | Last reply by Kevin Urquhart - Tuesday, August 20, 2013 5:39 PM - Items 1 to 20 of 13703 Next ›