Viewing 15 posts - 45,421 through 45,435 (of 49,552 total)
aj (7/27/2008)
Hi everyone!looping that query and for each record checking for a duplicate, and if its not, inserting it into my table.
If you're doing that in SQL, there's part...
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
July 28, 2008 at 3:34 am
It's usually recommended that no permissions be granted to public. Better way is to create a database role, grant the required permissions to the role then assign the role to...
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
July 28, 2008 at 3:33 am
Since you're doing daily summaries, I might suggest the date combined with a second column as the clustered index. Or I might not. It's hard to say without more info.
Could...
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
July 28, 2008 at 3:29 am
Why are you shrinking your databases in the first place? It is not something you should be doing on a regular basis. They will just grow again as soon as...
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
July 28, 2008 at 3:24 am
Sam Peascod (7/27/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
July 28, 2008 at 3:17 am
Please ask your DBA (who I assume has sysadmin permissions) to run the xp_cmdshell as requested earlier and see what results you get back.
With execute as 'sa'
Grant impersonate on user::'test'...
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
July 28, 2008 at 3:13 am
MrBaseball34 (7/27/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
July 28, 2008 at 3:12 am
Venkatesan Prabu (7/26/2008)
CPU time will show the amount of time (in milliseconds) taken to execute your query.
It shows the amount of CPU time spent while running the query. It's not...
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
July 27, 2008 at 12:00 pm
On SQL 2005, rather use sys.sql_modules. There's one row per proc/view now, rather than 1 per 4000 character chunk. Makes searching through the code a little easier.
Steve: Source Control?...
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
July 26, 2008 at 2:13 pm
My former company has a number of 64 bit servers, running windows 2003 or windows 2008 and SQL 2005 and they are rock solid. I would not recommend IA64, there...
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
July 26, 2008 at 10:33 am
Somebody would have dropped them. SQL doesn't drop objects by itself.
If it happened recently, you can check in the default trace to see if there's any info (default trace 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
July 26, 2008 at 10:24 am
Write simple queries and ensure that the can use indexes effectively
Create a clustered index that is unlikely to fragment fast.
Create a couple of nonclustered indexes to support frequently run queries.
Without...
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
July 26, 2008 at 10:15 am
To answer any of that I'd need to know what it's deadlocking with. To find that you, you can run profiler and capture the deadlock graph event, or 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
July 26, 2008 at 10:13 am
Mike Baria (7/25/2008)
Sure...but there's the rub...it never got implemented on a production server, yet it's in production. The dev server has other similar projects on it (in production but...
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
July 26, 2008 at 9:58 am
Truncating the log breaks the log chain. Once you're run it, you can't take any more log backups until you take a full or diff backup. They fail 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
July 26, 2008 at 9:54 am
Viewing 15 posts - 45,421 through 45,435 (of 49,552 total)