Viewing 15 posts - 45,931 through 45,945 (of 49,552 total)
maruf24 (7/5/2008)
gail cnt we reinstal sqlserver
That's a little extreme as a fix for missing counters.
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 5, 2008 at 10:39 am
If you query the dmv sys.dm_exec_connections, you will see the ip address.
I don't know of any way to lock someone out by IP. If they are using a specific...
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 5, 2008 at 10:35 am
Do you perhaps have a backup from before the attack hit? Restoring is probably the fastest way to clean up. Bear in mind, the attack may have done more than...
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 5, 2008 at 10:33 am
That would work in 2005. In SQL 2000, try rowcount.
SET ROWCOUNT @NumRows
SELECT *
FROM Northwind.dbo.Customers
ORDER BY NEWID();
SET ROWCOUNT 0
Please note, I don't have a 2000 server handy to test this. I...
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 4, 2008 at 2:46 pm
Can you maybe post the code of 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
July 4, 2008 at 2:09 pm
richard (7/4/2008)
Hi guys,I have just got back home having passed 70-431 🙂
Very pleased to gain my first MS certification!
Richard
Congrats! What was your score?
So, which exam's next on your list? :hehe:
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 4, 2008 at 2:04 pm
It should do. It is recommended that the statistics of all tables (in all databases) get updated after upgrading from 2000 to 2005.
The reason is that 2005 keeps more detailed...
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 4, 2008 at 2:03 pm
Vijaya Kadiyala (7/4/2008)
Hi,Finally when you are ready test ur-self against TestKing. This will tell you where do stand in.
Do NOT use testking. They are a braindump site. Their stuff 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 4, 2008 at 1:46 pm
This should get you started
SELECT execution_count, total_worker_time, total_physical_reads, total_logical_reads, total_elapsed_time, creation_time, st.text,
qs.sql_handle, qs.plan_handle, qp.query_plan
FROM sys.dm_exec_query_stats qs INNER JOIN sys.dm_exec_cached_plans cp ON qs.plan_handle = cp.plan_handle
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st
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 4, 2008 at 5:43 am
You could disable the trigger, run the delete and reenable it. There's the risk that another delete runs while the trigger is disabled.
Is there anything about the session/connection properties that...
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 4, 2008 at 4:51 am
Jonathan Mallia (7/4/2008)
I cannot do this as i must use the date in question for querying in reports etc
You said you wanted to change the dates to something like '1900/01/01'?
If...
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 4, 2008 at 3:34 am
Have a look at this kb article, see if it solves your problem
http://support.microsoft.com/kb/300956/en-us
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 4, 2008 at 3:02 am
I would sugget that you import into a staging table where the column is of type varchar, do any validation and correction that you need thre, then import into 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 4, 2008 at 2:51 am
karthikeyan (7/4/2008)
The suggestion of a comma-delimited list in a single column violates the first. It it often suggested as a 'solution', but tends to cause mor problems than it solves....
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 4, 2008 at 1:24 am
Not those. Those are OS-level counters. What about other SQL-related counters?
(SQL Server:Access Methods, SQL Serveer: General Statistics, ....)
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 4, 2008 at 12:43 am
Viewing 15 posts - 45,931 through 45,945 (of 49,552 total)