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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 Search options user 820

SQL Server 2005 (major build version 9.00.xxxx). Please also tag sql-server.

3
votes
The difference between one and two queries may not be as large as you'd think. For example, compare this query: declare @t table (id int) insert into @t select id from Table1 where col1 = 7 update Ta …
answered Apr 7 '12 by Andomar
2
votes
A well known SQL Server expert, Paul Randal, recommends that the number of tempdb data files should equal the number of logical cores. So if you have 4 CPU's with hyperthreading, you'd create 8 tempd …
answered Sep 4 '12 by Andomar
1
vote
This line says there can be no LastAssignment turned on: CHECK (dbo.FN_IsLastAssigned(ClaimId)=0) It should probably be: CHECK (dbo.FN_IsLastAssigned(ClaimId)<=1) Note that check constraints li …
answered Jul 5 '12 by Andomar
20
votes
You could create a stored procedure that runs the job. You can use with execute as owner to run the stored procedure as the database owner. That way, the users themselves don't need permissons on sp …
answered Dec 31 '09 by Andomar
12
votes
The query optimizer treats an inline table valued function exactly like a view: CREATE FUNCTION dbo.InlineUdf(@arg1 int) RETURNS TABLE AS RETURN ( ... your query here ... ); A multi-statement …
answered Aug 14 '12 by Andomar
5
votes
Drop any foreign keys Create new tables with int instead of tinyint Move the rows over per batch of 1000 (insert them in the new table, delete them from the old one) Drop the old tables Rename the ne …
answered Jun 27 '12 by Andomar
12
votes
For SQL Server 2008 and up, you can disable promotions for the linked server. It's on the Advanced property tab, or you can script it like: EXEC master.dbo.sp_serveroption @server=N'YourLinkedS …
answered Jul 17 '13 by Andomar