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

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 …

822 views
Enterprise Mobility and BYOD For Dummies
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

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…

627 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…

522 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 …

225 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 …

323 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.

137 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…

4531 views

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 …

1132 views

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

Thanks.

855 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…

1050 views
Back Up Your Microsoft Windows Server®
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

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 …

425 views

(CODE)

636 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:\ …

861 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 …

342 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.

224 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 …

628 views

I use SSMS often and have used SSRS as well.

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

340 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.

436 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 …

433 views
Free eBook: Backup on AWS
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

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…

746 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 …

438 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

337 views

I have never used EXCLUDE or INTERSECT but hope to do so soon.

Please list mainly when JOIN would not work but EXCLUDE or INTERSECT would.

Thanks.

748 views

I have a working Common Table Expression and would like to make it into a View.

How do I do that?

Thanks

1539 views

I've come across a strange issue which I haven't seen before and cannot figure out what is going on.
The stored procedure will be used in an SSRS Report and contains a fair number of temporary …

2455 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