Viewing 15 posts - 12,826 through 12,840 (of 49,552 total)
Bulk Insert does not fire triggers by default. If you want a bulk insert to fire triggers, you have to specify.
From Books Online entry titled BULK INSERT:
FIRE_TRIGGERS
Specifies that any insert...
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
June 10, 2013 at 9:32 am
Exactly the same behaviour no matter where it's called from and no matter whether it's a procedure or ad-hoc code.
Yes, see if you can tune it, especially if you 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
June 10, 2013 at 9:18 am
Probably has nothing to do with the generation of the execution plan.
The first time a query runs, the data is read off disk into the data cache. Subsequent executions 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
June 10, 2013 at 9:05 am
Just means that SSMS has been disconnected. Could have been someone killing the connection, could have been SQL restarting.
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
June 10, 2013 at 8:49 am
What does this return?
select count(*)
FROM [LOAD_SCHED] as T1 inner join [Arch_LOAD] AS T2 on T2.[Arch_Key] = T1.[Live_Key]
select count(*) from LOAD_SCHED where Live_Key IS NULL
select count(*) from Arch_LOAD where Arch_Key IS...
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
June 10, 2013 at 6:55 am
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
June 10, 2013 at 6:28 am
arooj300 (6/10/2013)
Could you please tell me here deleted is the column name or table name, because in SQL SERVER we use inserted and...
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
June 10, 2013 at 6:28 am
No, it would not have shown up in the SQL error logs, it would have shown up in the default trace.
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
June 10, 2013 at 5:33 am
You can check the default trace for both data and log files, autogrow events are logged. The trace may have rolled over though, it only keeps 5 files of max...
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
June 10, 2013 at 5:21 am
That's Oracle code, not SQL Server. Maybe ask on an Oracle forum?
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
June 10, 2013 at 5:09 am
HowardW (6/10/2013)
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
June 10, 2013 at 4:08 am
Check the VM settings to ensure that the VM really does have that much memory and doesn't just appear to have it. Make sure the VM host isn't stealing back...
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
June 10, 2013 at 4:05 am
saurabh.deshpande (6/10/2013)
Need your suggestion here.Do I need take up 2008 or it better to go for 2012.
Up to you. Do you see a value in having a SQL 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
June 10, 2013 at 4:00 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
p.s. OS error 5 is Permission Denied. SQL doesn't have permissions to access the new location.
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
June 10, 2013 at 3:58 am
The 2012 exam has been out for about a year now, it's hardly a very new exam.
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
June 10, 2013 at 3:43 am
Viewing 15 posts - 12,826 through 12,840 (of 49,552 total)