Questions tagged [sql-server-2005]
SQL Server 2005 (major build version 9.00.xxxx). Please also tag sql-server.
1,327 questions
0 votes
1 answer
99 views
SQL SELECT: restrict rows from Table1 to those having only specific rows in Table2
(A simplified example). I have Table1 with items: +----+-------+ | id | name | +----+-------+ | 1 | car | | 2 | apple | | 3 | grass | | 4 | alien | +----+-------+ and Table2 with colors that ...
- 3
-1 votes
1 answer
118 views
Is it possible to create fast (ram only) temporary table for inter software communication purposes in MS SQL Server?
I was wondering that is it possible to create a table that is really fast and temporary (basically one that resides in ram) in MS SQL Server 2005 or later for inter software communication purposes? Do ...
3 votes
1 answer
340 views
Upgrading out of support Microsoft SQL instance multiple questions?
I just got a new job as an analyst but I’m being tasked with an administrator task and just looking for insight. We have a Windows server 2003 (32bit) that has Microsoft SQL Server 2005. I have been ...
- 31
0 votes
1 answer
488 views
Issues with SQL Server DB Migration
I have two instances of Microsoft SQL Server. One is running MSSQL 2005 and the other is running MSSQL 2019. We recently migrated our DB engine from 2005 to 2019. We have a webserver that runs off IIS ...
- 3
0 votes
1 answer
771 views
Anything but small ODBC queries failing over long distance VPN after SQL Server Swap
I recently swapped database servers (restored databases from old to new and then swapped IPs)... Old: Sql Server 2005, Windows Server 2003 New: Sql Server 2008, Windows Server 2012 All processes ...
- 629
0 votes
0 answers
236 views
SQL2005 Index exists in sys.indexes but not on table
I have a routine that runs through all the non-clustered indexes in a given database on SQL2005 (SP3), and reorganizes and rebuilds them (if fragmentation > 20%). This process is erroring out on ...
- 95
0 votes
2 answers
11k views
Materialized view in SQL Server
Have a bit of glitches from the time I was using SQL Server back in 2006 and the many other databases I played with (and which I have not touched since then). I need to create a materialized view to ...
- 255
1 vote
1 answer
149 views
Update statistics
For the data retention purpose I am deleting records from some 60 tables. Some of the tables have less number of records while some have more. I don't want to update the stats for all the tables. Is ...
