Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server-2008
Search options not deleted
user 9738
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
2
votes
3
answers
1k
views
SQL Server tempdb question
From what I understand the system database is used to hold temporary tables, intermediate results and other temporary information.
On one of my database instances I have a tempdb that is seems very l …
- 479
1
vote
3
answers
3k
views
Can't create indexes on really large table!
I have a table with over 300 Million rows in it. When I try to create an index on the table I get the error message below.
Msg 1105, Level 17, State 2, Line 3 Could not allocate space for
objec …
- 479
3
votes
Accepted
SQL Server 2008: Diff table data on different servers with exact schema
Is creating a linked server on one of those an option? If so you could probably do this using something similar to the following query (untested):
INSERT INTO Server1.db1.dbo.Table1
SELECT * FROM db …
- 479
6
votes
1
answer
4k
views
How much of a view is persisted when you create an index?
Say I have a view defined by the following SQL:
SELECT t1.id, t2.name, t3.address
FROM Table1 as t1
INNER JOIN Table2 t2
ON t1.id = t2.tID
INNER JOIN Table3 t3
ON t1.id = t3.tID
From what I und …
- 479