SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• It is a linked server error Login failed for user 'NT nt authority anonymous logon'

  SQL Server 2008 R2 instances are installed on machine A and B respectively. Also, A is the middle s…

  Guras

  5 replies

  14 years ago

  By: Gazareth

• Store procedure back up

  How could i take a store-procedure backup in sql sever 2008 without taking a script backup. Actual…

  pallavi.unde

  3 replies

  14 years ago

  By: Grant Fritchey

• Hyperlink not working in sql server

  I am working on migrating data from access to sql server by using sql server migration assistant fo…

  park1432

  1 replies

  14 years ago

  By: vinu512

• Working with an ID column and SQL. ("newid").

  SELECT TOP 10000 newid, * FROM [original-data] WHERE State="PE" ORDER BY Zip; The column "newid" d…

  sepich.eric

  3 replies

  14 years ago

  By: Lynn Pettis

• Get Data from IBM Cognos TM1 (SQL)

  Hello, does anyone know a way to connect OLAP cube data from Cognos TM1 using OLE DB Provider or wh…

  info 58414

  1 replies

  14 years ago

  By: j.webber

• update stats job

  is it advisable to stop the update statistics job while its still running on prod env...its taking …

  Pyman

  4 replies

  14 years ago

  By: Pyman

• how to write a select store proc for this using four or more table for report generating ?

  for example here i am using five table? table1 catid categoryname 1 cricket 2 foo…

  Sivaganesh Tamilvendhan

  1 replies

  14 years ago

  By: Lynn Pettis

• How to reorganize and rebuild all indexes

  what is the best way to reorganize and rebuild all indexes of database?

  banda.sai

  2 replies

  14 years ago

  By: Orlando Colamatteo

• Getting Estimated Row Equals 1 instead of Actual Row Equals 250,000

  Please refer to the query below: DECLARE @applicationID int = 203, @logType varchar(50) = 'all', …

  sbradford 35239

  2 replies

  14 years ago

  By: sbradford 35239

• Why Trigger????

  I have been asked in an interview.. why should we go for trigger when we can achieve the same by th…

  SqlStarter

  6 replies

  14 years ago

  By: GSquared

• Get counts grouped by time range

  Hi everyone, I have a table that holds all the user log in data... basically, when a user logs in…

  Tony Farrell-305085

  11 replies

  14 years ago

  By: Lynn Pettis

• steps after data purge

  I am going to do data purging in my databases. I guess it will have around 20% of data will be remo…

  stephenhai

  3 replies

  14 years ago

  By: Rudyx - the Doctor

• Disadvantages of Transactional Replication

  Dear All, I would like to find more about the Disadvantages of Transactional Replication as it is t…

  tt-615680

  6 replies

  14 years ago

  By: tt-615680

• SQL 2005 BCP

  Need help in exporting single table having 25 million records to multiple flat files of less than …

  CoolDude7645

  2 replies

  14 years ago

  By: Suresh B.

• Find infinite cycle in a tree

  I have a table with a tree structure (IdIndividual, IdMother, IdFather). Is there a way to find if …

  ralu_k_17

  5 replies

  14 years ago

  By: GSquared