Viewing 15 posts - 46,351 through 46,365 (of 49,552 total)
Sure. Works in 2005 just fine
DECLARE @TimeStamp VARCHAR(4)
SET @TimeStamp = REPLACE(CONVERT(VARCHAR(10),GETDATE(),108),':','')
EXECUTE ('CREATE DATABASE TEST_DB' + @TimeStamp + ' ON
( NAME = TEST,
FILENAME = ''C:\SQL2005\Snapshot\TEST_DB' + @TimeStamp ...
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
May 28, 2008 at 5:22 am
Ok, you could try something like this (replacing placeholders with pertenant values)
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;
User Id=myUsername;Password=myPassword;
What version is your SQL Server (run SELECT @@Version)
Can you connect from query analyser using 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
May 28, 2008 at 5:12 am
Do you have the log file as well (ldf). If not, you'll have to use the attach_single_file proc and hope that the DB was shut down cleanly.
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
May 28, 2008 at 4:46 am
Much lighter than profiler. Make sure that the trace is writing to a fast drive that does not contain your database's data or log files or tempdb.
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
May 28, 2008 at 4:45 am
karthikeyan (5/28/2008)
How to understand US or UK accent easily ?
You'll get used to it in time. There's no quick solution. For now, it's up to you to make sure...
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
May 28, 2008 at 4:44 am
Firstly, don't ever, ever, ever, ever use the sa account for an application's login. You're asking for security problems.
Create an account just for the application that has just the permissions...
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
May 28, 2008 at 4:39 am
Have you done any index rebuilds lately?
Rather stay away from shrinking. Often you shrink the file and the next thing sQL needs to do is grow it again. It can...
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
May 28, 2008 at 12:16 am
niranjankumar_k (5/27/2008)
if i create index after BCP , further i do deletion and updation .. so it will reduce performance due to cluster index creation .
Have you tried it?
Unless...
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
May 28, 2008 at 12:04 am
Oh sure.
The 'hit recursion limit and roll back' was based on the assumption that there's no 'escape clause', that the trigger's been written to recurse 'forever'
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
May 27, 2008 at 2:20 pm
By default triggers cannot fire themselves. (recursive triggers disabled) so 2 rows will go in, but the second won't fire the trigger
If you have recursive triggers enabled then the trigger...
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
May 27, 2008 at 1:56 pm
You didn't miss anything. DTA has a very bad habit of massively over-suggesting indexes and statistics. Take its suggestions with a large pinch of salt.
I would suggest that you try...
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
May 27, 2008 at 1:46 pm
Pleasure.
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
May 27, 2008 at 1:37 pm
Are you familiar with the group by clause and the aggregation functions in a sql statement?
The aggregations (in this case SUM) get the columns you're trying to aggregate as a...
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
May 27, 2008 at 1:22 pm
The inside SQL Server 2000 book and the Inside SQL Server 2005 series are excellent. Kalen Delaney, Itzik Ben-Gan and others
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
May 27, 2008 at 11:28 am
duplicate post
http://www.sqlservercentral.com/Forums/Topic506818-338-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
May 27, 2008 at 11:22 am
Viewing 15 posts - 46,351 through 46,365 (of 49,552 total)