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

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 …

242 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 am just wondering...

421 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?

215 views

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

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

520 views

With the following database...

(CODE)

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

Thanks

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

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

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

720 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?

450 views
Optimizing Cloud Backup for Low Bandwidth
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

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

533 views

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


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

79 views

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…

828 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.?

318 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

521 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   =…

512 views

hi experts

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

which T-SQL?

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

422 views

Using SSMS, how do I index on timestamp field?

Thanks.

526 views
Visualize your virtual and backup environments
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

hi experts

i am reading about Database Mail Profiles

In which cases should you use a public or private profile?

Profiles can be private or public. Private profiles are strictly controlled and…

122 views

I believe there are numerous columns on my table, perhaps my entire database and maybe even every database I need to support...

which have nvarchars defined with far more size than needed.

So, …

925 views

I have a query which groups the exceptions table by Message Name.

At the moment, I am grouping by the Title and find over a million records with the sale title: "SF Upsert". That's short for …

322 views

We installed SQL Server 2008 STandard SP3.

When we installed we did not choose the box for SQL Brower and I can not enable it.

Can I simple rerun the SQL Server Setup and add it????

833 views

Hello.  I'm looking for the correct way to locate and then delete some records in my database, and need help with forming the SQL.  What I have are some records that have an "item code" and a "barcode…

642 views

hi,

right now want to learn more and do more on Microsoft BI, what source you recommend to start with for beginner to experts.

1) URL
2) books.

all welcome.

1350 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