SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Performance on very large database - Help

  Hi, I have a very large table (14 billion of record) and I have to query this table by web applicat…

  aGuareschi

  17 replies

  14 years, 10 months ago

  By: TheSQLGuru

• How to debug jobs?

  :hehe:How to debug jobs? I have one typical problem,In one of our site the DNS has changed from Lin…

  forsqlserver

  3 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• 2008 R2 Upgrade Advisor Error - ActiveX Component can't create Object

  I'm preparing to upgrade a SQL 2008 Enterprise Analysis Cluster to SQL 2008 R2 Enterprise. When I …

  Steve-443559

  2 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• SQL 2008 r2 default instance connection problm

  I installed sql 2008 r2 on windows server 2008 r2 enterprize edition. SQL installed smoothly but wh…

  shah_rajen

  7 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• openrowset - error because of Dot (.) in column name

  Hello, I'm trying to use 'openrowset' to query and/or update a table in a remote database. Usually,…

  marwa.elghali

  5 replies

  14 years, 10 months ago

  By: ChrisM@home

• dm_os_wait_stats for a single database

  I have a myriad of different databases running on a database instance. The wait stats that I'm seei…

  @SixStringSQL

  3 replies

  14 years, 10 months ago

  By: Grant Fritchey

• openquery - stored procedure

  Hi, Guys I wonder is possible to make stored procedure which will be called different stored proced…

  nikplic

  14 replies

  14 years, 10 months ago

  By: Jeff Moden

• Service Broker queue growing

  I had a problem using SQL 2005 Service Broker where one day, the transmission_Queue and destination…

  T Moore

  2 replies

  14 years, 10 months ago

  By: Syed Jahanzaib Bin hassan

• Any Alternatives to installing MS Office on SQL server 2008 server

  I have a SQL server 2008 server. I have a user whose SSIS package (which runs on the server via a a…

  deepmustang 90114

  2 replies

  14 years, 10 months ago

  By: deepmustang 90114

• Create SQL Views from 2 different tables!

  Hi, I have two tables, which are different with unequal number of columns (4 vs 1 column). And I wa…

  asterman_3

  6 replies

  14 years, 10 months ago

  By: asterman_3

• How to find a temporary table in tempdb?

  I tried to find a temporary table by selecting from tempdb.sys.tables. However I can see only ## gl…

  SQL Guy 1

  23 replies

  14 years, 10 months ago

  By: Jack Corbett

• CLR SP server param

  Hi Im passing a value into a clr sp and that value is a printer on the network, I've tried doing a…

  raymond.bell

  1 replies

  14 years, 10 months ago

  By: jerry-621596

• SSRS 2008 for SL

  Does anyone know if SSRS be used for SL4?

  raymond.bell

  6 replies

  14 years, 10 months ago

  By: Revenant

• Alerts only fire the fact? Surely this can

  I've setup an alert that executes a job with a single stored procedure that collects blocking infor…

  SQLHeap

  3 replies

  14 years, 10 months ago

  By: SQLHeap

• Excel file smaller then when saved again as xls

  I have one Excel file *.xls (its sent by e-mail from some application I don't know) that comes with…

  joao.picarra

  2 replies

  14 years, 10 months ago

  By: joao.picarra