Microsoft SQL Server

157K

Solutions

184

Articles & Videos

48K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Related Topics

  1. Microsoft SQL Server 2005
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. Microsoft Access
  7. Microsoft Development
  8. ASP.NET
  9. SSRS
  10. Visual Basic.NET
Refine results

Hi,

Tried a fairly straightforward install of SQL 2014 to a Win 2008 R2 box that had SQL 2008 on it earlier(but uninstalled).  The only settings I changed from default was the location of the …

936 views
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I want to query 8 string/columns (NOT ROWS), the only stipulation is that there can't be more than 4 of the columns matching in the returned row. For example:

col1, col2, col3, col4, col5, col6, …

1430 views

Hello Experts,

I am an independent contractor. I make custom reports and maps for police departments. I use Crystal Reports, T-SQL to prepare scripts for handling data, and ESRI for mapping crime, …

520 views

I need some help with SQL Select to identify records that contain the same "New Feature" descriptions just in a different order.  I have a table containing a list of products with each product …

524 views

This issue appears to be universal in all versions of SQL Server.

Attempting to import text fields from a flat file that have CR/LF embedded in the text results in errors. The incoming flat file …

717 views

I need to upgrade one of our QA test sites to have the exact version of every service running in Production, and to have some form of mirrored database running on the QA site. I guess it's mainly that…

217 views

He experts,
would you please tell me which of the above is a better database and why ?
Please if possible main advantages and disadvantages ?
Regards

620 views

I have an existing report that I want to add a calculated field that I can later filter.  The report shows columns for "available", "qty_in_process" and "qty_for_production".  I want to be able to sum…

418 views

Quick question on how to get a neglected question back into the active queue?  There used to be a button to request assistance on them but it seems to be missing now...?

Thanks,
Greg

313 views

I have the following query that I use as a part of a custom search engine on my site. I've stripped it down for readability, the joined tables will have columns in the select clause, that's why …

1849 views
Best Practices: Disaster Recovery Testing
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Hi

I have two tables

Create Table Doctor
(
    DoctorID as  Int,
    HasPatients as varchar(1)
)

Create Table Patient
(
     PatientID as Int,
     DoctorID as Int    
)

I need an …

210 views

I ran this:
exec sp_spaceused 'Log'

against this table:
(CODE)



and got:

name: Log      
rows: 13481381                  
reserved: 55532040 KB      
data: 34530600 KB      
index_size: 20993832 KB      

1220 views

I am trying to determine the patients last appointment location, everything is fine until i add "location" field then i produce more results,since a patient more than likely has been treated in more …

419 views

I heard the term and did not understand the quick explanation I saw.

What is an equi-join?

Thanks

316 views

Hi Expert,

In the following query i was trying to pull reportdate and the where condition was like. If i use like for one set ipaddress then it returning value if i put in a range then it wont. …

512 views

In my following code I am getting ONLY the top phone number for the individuals from the Phone.*

This...
(CODE)

Gets me this...
(CODE)

When I want this...

(CODE)

431 views

I have a table and need an Index.

I assume this will speed up performance since every query I execute against this table (with 15 million records) will filter by the last one year.


(CODE)

1514 views

I have a table with rows of data and I need to create one row of data that has multiple columns,  

Table1
 
ord           color
1               ink1
1              ink2
1              ink3
1 …

1231 views

In SQL

select (getdate()-1)  will give  a day older ...

I need records .. which is less than 5 mins or 10 mins ..

How do i fetch it from getdate()

217 views
Edgartown IT Case Study
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

hi there
i have table that hold moves for customer like in the bank
there is withdrawal and deposit this is sample :
from start date : 01/01/2017 to 15/01/2017

MID      MDATE     CID    SUM  …

817 views

I have wrote following trigger after that Sql server not working how to resolve this

I think , this the issue "ROLLBACK; " how to remove the Trigger. so i can't connect the SQL server using …

251 views

Hi

I have this data.  I need to get the 3rd field after the ^ in a SQL statement  I am always sure  the data will have this format. Using SQL server 2012

sc^00001JU4QF^129920189^201211070033

314 views

I am just wondering...

424 views

Hello, I have a Sql Server stored procedure that return a single record with two columns in it (Role_Id and Program_Id). I currently have a function in Asp.Net VB.Net that will execute the Stored …

213 views

I have the following sql update statement but need to get the minimum receipt date

(CODE)
I tried to finish the statement but don't know if I am on the right track.  I have multiple lines that …

413 views
Show more content
201506-LO-Top-001

Microsoft SQL Server

157K

Solutions

184

Articles & Videos

48K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Related Topics

  1. Microsoft SQL Server 2005
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. Microsoft Access