SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Permissions to do SQL Compare

  Hi, I would like to know what permissions exactly the Login should've, inorder to do SQL Compare be…

  ajay.g

  1 replies

  14 years ago

  By: Grant Fritchey

• Who is using my linked server ?

  Does anybody know of a nice way to see if a particular linked server is being used by a view/job/pr…

  oskargunn

  2 replies

  14 years ago

  By: oskargunn

• how to write a select query with out passing parameter for this tables ?

  he i am having 3 table i need to write 2 select query depend upon the @table3 declare @ta…

  Sivaganesh Tamilvendhan

  7 replies

  14 years ago

  By: vinu512

• how to load data to server through ssis

  Could you please tell me how to load below mentation data to server through ssis. i have used colum…

  subbu1

  2 replies

  14 years ago

  By: subbu1

• SQL SERVER PERFORMANCE ISSUE

  Dear Friends, I have a table having 8 to 10 crore data in this table and i want to transfer top 100…

  shubham.saxena67

  2 replies

  14 years ago

  By: Gullimeel

• Switching number with counting

  I have tried to use Row_Partition and Dense_Rank to get ‘switching number with counting.’ SQL is qu…

  athens1234

  19 replies

  14 years ago

  By: athens1234

• SQL Server 2008 R2 cluster licensing

  Hi Experts, I am planning to set 2 node active/passive cluster with two sql instances in sql server…

  Bipsy

  2 replies

  14 years ago

  By: okbangas

• Problems with SQL2008 / Windows 2008 R2 cluster install

  Hey all, my cluster install failed with the following error: There was an error setting private pro…

  Adam Bean

  8 replies

  14 years ago

  By: patamons

• TRANSACTION ISOLATION LEVEL

  HI what is the difference between Snapshot Isolation Level and Read Committed Snapshot? Both of the…

  mah_j

  3 replies

  14 years ago

  By: vinu512

• Excel to Database - can you help?

  Hello, I am developing a new utility 'Excel to Database' providing easy batch data upload/insert fr…

  C# Gnu

  4 replies

  14 years ago

  By: C# Gnu

• ssis package performance tuning (reduce time )

  Hi, in the ssis package in dataflow i am taking three OLEDB sources and everthing sorting and then …

  sureshsr23

  1 replies

  14 years ago

  By: Koen Verbeeck

• How to substract from one column to another ?

  Card_NoCheckIn CheckOut Duration 1442012-05-17 10:01:34.00…

  sachince61

  7 replies

  14 years ago

  By: vinu512

• What are the best resources for learning SQL Server Business Intelligence?

  I have a pretty good understanding of T-SQL, and I use SSRS all the time. (Although I wouldn't cal…

  David Moutray

  7 replies

  14 years ago

  By: David Moutray

• Does the database with huge ldf file takes long time to restore?

  Does the database with huge ldf file and smaller mdf file takes long time to restore compared with …

  SQListic

  4 replies

  14 years ago

  By: Gail Shaw

• Applying Transaction logs to an O/S backup

  We are looking into options for backup and restore for our new database that is going to be about 5…

  Gary Bourne-389258

  20 replies

  14 years ago

  By: dustin_prescott