Viewing 15 posts - 42,376 through 42,390 (of 49,552 total)
If you can, create a NC index to support the other searches on the table. If that's not possible, or you want a NC just for the count, then put...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2008 at 11:36 am
Grant Fritchey (12/14/2008)
To really answer the question, you've got to post the execution plans.
And the query, the table schemas and index definitions please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2008 at 8:52 am
If it's a desktop at home, local system's fine.
It's not recommended for use in production systems because it has too many privileges and has no access to other machines.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2008 at 8:48 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic619044-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2008 at 2:42 am
timothyawiseman (12/13/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2008 at 2:39 am
udayaraju_v (12/12/2008)
I need Login as "sa" and empty Password ""..is ther any possibilty..please suggest me...
I would very, very strongly recommend that you do not do that. A server with the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2008 at 2:54 am
What's the error?
For the full error, go to the job step properties, to the advanced tab and enter a file name for the job output. Full error will be in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2008 at 2:47 am
You can query sys.dm_exec_sql_text and pass it a sql_handle (which you can get from sys.dm_exec_requests and several other DMVs)
It's not exactly the same output as inputbuffer. Inputbuffer will show the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2008 at 2:46 am
nairsanthu1977 (12/13/2008)
Whats native restoration process..? Can you explain in detail pls..
RESTORE DATABASE ... FROM ...
See books Online for the full details. Or, from Object Explorer, right click the databases folder...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2008 at 2:43 am
Try attaching them. It should work.
From object explorer, right click the database folder and select Attach Database
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2008 at 2:42 am
ALTER TRIGGER [dbo].[trTest]
ON [dbo].[NotesF_Devices]
AFTER UPDATE
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2008 at 1:14 pm
Steve Jones - Editor (12/12/2008)
First thing I do, and used to require in dev teams, is to set tools to replace tabs with spaces. Creates all kinds of issues.
I used...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2008 at 9:27 am
The_SQL_DBA (12/12/2008)
1.How is the process supposed to work?
That's a bit of a vague question.
How would the process of querying the table with ref to this column work after encryption?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2008 at 9:25 am
jcrawf02 (12/12/2008)
lol y'all are nuts.
Hehehe :hehe: You only just noticed?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2008 at 7:12 am
In the first statement, both of those numbers are integers. When SQL does maths on two integers, the result will be an int. In this case, the result is too...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2008 at 4:24 am
Viewing 15 posts - 42,376 through 42,390 (of 49,552 total)