Microsoft SQL Server 2008

49K

Solutions

24

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 Experts;

I am attempting to connect to a 2008 r2 SQL server over the internet. The server provides database connectivity for a LAN without issue. Attempts to connect through the public facing…

424 views
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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…

219 views

I have a CLR Assembly that I have loaded on two separate servers the exact same way.

On one server the function that calls the assembly works perfectly

On the other I get this message.
Makes no…

816 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      

1221 views

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

What is an equi-join?

Thanks

317 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)

1515 views

I have a large data-table Logging.dbo.Log

and I am trying to copy records newer than one year old to a new table to make t easier to query.

But the query (below) terminates dur to the error:

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

253 views

I am just wondering...

425 views

We are getting errors that require us to install flash. We want to force the installation with no user input. Can this be done using GPO?

221 views
Three Reasons Why Backup is Strategic
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

How can I do a select that replaces all carriage returns and tabbed sections in the data?

210 views

I need to query a huge Log table that has years of data, and have a plan to improve performance.

I want to create a Map table with one column only, would be a foreign key and it would contain the …

529 views

With the following database...

(CODE)

if it has 14.5 million records, how big might this table me?

Thanks

722 views

I have an exceptions Log table where I will be extracting new records to place into a backup table with the identical schema.

Here is the CREATE query from my Log table

(CODE)

My question is…

414 views

I am using Microsoft SQL Server 2008

I tried using the following stored procedure but when I execute it, I get an error as follows:

Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the …

19 views

I need query an exceptions table with 14 million records and extract only records from the previous 1 year. There is a datetime field which contains the creation date for that row.

How do I write …

724 views

I want to include records from the last one year but have trouble casting the date...

WHERE Cast(sfl.[DateOfException] as date) > DATEDIFF(year, -1, GETDATE())

What is wrong with this syntax?

453 views

I am interested to learn more on the topic. I need to consider query performance on an exceptions table with over 13 million records.

Thanks

539 views

What query could I use to see if Index/Key  IX_Flag exist in table MyDataTable


Example:
SELECT FLAG
WHERE .............
--------------------

711 views
Free Webinar: AWS Backup & DR
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

I have an exceptions log file where I need to group by Message, then by FormattedMessage.

Message: Exception of type 'System.Exception' was thrown.
FormattedMessage: Error while creating Potential…

831 views

Hi,

  I want SQL profiler for windows 7 32 bit.We are using SQL express edition i our companies.I have a one doubt, SQL profiler tool is available for express edition or standard edition.?

321 views

Hello Experts!

I am OK with queries when it involves one table but not so great with multiple table and filtering. I have the following issue i hope someone can help me with:

Tables

525 views

I need to add a date  or datetime field to a table that is populated from the value of a char(14) field

How can I convert the char(14) TimeStampInfo field below to a date time

TimeStampInfo   =…

515 views

hi experts

i need denied (Avoid impersonation)
execute as login
and
execute as user

which T-SQL?

1333 views

14 million records is not that big, but is too large for me to do "what if" queries without such a long response time, I lose my train of thought.

 I need to create some form of order on the data …

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

Microsoft SQL Server 2008

49K

Solutions

24

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