Microsoft SQL Server 2008

49K

Solutions

23

Articles & Videos

17K

Contributors

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Related Topics

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

Hello,

I've a function which returns comma separated values like
Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday

I've seven columns i.e. Monday to Sunday in SELECT query. I need to …

525 views
Free Tool: SSL Checker
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hello,
Is there a way that I get all values from a column in uppercase .

Example :
TableA

Col1 Col2
abc   gh
dff     fggg

Select * from TableA

Result expected

Col1 Col2
abc   GH…

212 views

Hello,

I have query which specifies 'ON Job' based ob the collection date
(CODE)

Need to change the ' on job'  criteria if the A.StartDate = 23-May-2017  and A.EndDate =26-May-2017 then it …

2022 views

In my sql below I get a result set of technical "duplicate" records.

What I need is to add a column that show the "Parent" record.
If row = 1 it is IndividualID

If row > I it is Row 1 …

827 views

select * from syslogins where sysadmin=1

gives

sa
BUILTIN\Administrators
NT SERVICE\SQLWriter
NT SERVICE\Winmgmt
NT SERVICE\MSSQLSERVER
NT SERVICE\SQLSERVERAGENT

and if sa became locked…

633 views

Hello Guys

I am trying to Post my URL through this store proc but it doesn't work for me.

I'd like to know if it works for you and if not, What I need to do to fix it or maybe you have a better…

531 views

I'm using sql server 2008

I have a table called MyCompanyEmployees that looks like this:



This the script to create this table:

(CODE)

I have another table called MyCompanyTable1 that …

232 views

I want to check if a value is present in a field, if it is not present (null) then I want to set the value to be set to todays date using the GETDATE() function

This has to happen via a stored …

326 views

I have a CLR procedure that calls a web service within, and the web service returns a JSON string back with 3 'elements' within it.
I'd like to parse these 'elements' out into 3 separate columns.

143 views

Hello,
I have a query to solve, any suggestions are appreciated :
Need to check who has collectiondatetime for today, the person having it today is on job and the rest are available.  


Table A…

4541 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

hi,

usually we have some perfmon counter for RAM:

Index searches /sec  >1000 will have warning. >2000 will have critical message.
SQL Compilations/Sec >100 will have warning ,>300 will have …

1140 views

I have not ever used a cursor, so please explain when they are useful and how to use them.

Thanks.

861 views

Hi.  I have been using SQL Server 2008 R2 database mail for many years to send emails from my systems.  

Here's my scenario.  I have stored procedures with different logic that create records in an…

1057 views

After the first switch statement
(CODE)

which sets @APNoPrefix

I need to do a test and reset @APNoPrefix if it has a value of 'CZE'

But I don't get the syntax in T-SQL for this simple If …

432 views

(CODE)

647 views

Hi People,

I've got about 8x SQL Servers VM that is used 24x7 and very big, with some of them is around 12.5 TB in single VM (multiple large VMDK):

16x vCPU
128 GB vRAM
C:\ - OS - 300 GB
D:\ …

874 views

Hi experts,

I'm using sql server 2008.
I'm using the Orders table from the Northwind database.

This is the script for my table:

(CODE)

So the Orders table looks like this. Notice how it …

348 views

Hello Experts,
Is there any way to search a Column name used in Views just like we search Stored Procedures?  Please let me know.

Thank you in Advance.

228 views

I'm working on a project and we have a geometry column. I'm querying the database to get the data , send it to Mapbox and display it on the US map.

Now, the query is slow and someone at work says …

633 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!

I use SSMS often and have used SSRS as well.

What does SSIS do? What are the biggest features of SSIS?

344 views

Are the rows returned from two tables when using INTERSECT on those two tables the exact opposite set of rows returned with a FULL OUTER JOIN on those same two tables?

Thanks.

441 views

On my Exceptions table, with 15 million records, I found that the Clustered index is the default, on the primary key Log_ID. I was considering making a Clustered index on the "Timestamp" column (the …

439 views

I am considering investigating a career change to a Database Admin from a C# .NET developer with some SQL and database skills.

What are the biggest things a typical DBA is needed to do on a typical…

755 views

Experts,

I have a table that looks like this:

Name
---------
Column_1_Name
Column_2_Name
Column_3_Name
Column_4_Name
...
...
Column_10_Name

The "Column_xx_Name"  is the literal data …

443 views

Experts

I'm dealing with the following issue:
I need to know how to use a VARIABLE as a linking-field in a SQL QUERY.

declare @variable1 varchar(30) = select top 1 fieldname1 from table_3

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

Microsoft SQL Server 2008

49K

Solutions

23

Articles & Videos

17K

Contributors

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2005
  3. Query Syntax
  4. SSRS
  5. Databases
  6. Windows Server 2008