13 hours ago by Jugal Shah

A deadlock occurs when two or more processes permanently block each other by each process having a lock on a resource which the other process are trying to lock. Please execute the below queries as per the mentioned comments to produce a deadlock. --turning on the traceflag to record deadlock info i ...

SQLDBPOOL.COM - sqldbpool.com · 21 references

5 days ago by _^ - ^ worldIT ^ - ^_

Link Direct Link Direct - SQL Server 2008 - 3.75 Gb Link Direct Link Direct - SQL Server 2008 - Link Direct, Link Direct - SQL Server 2008 - Link Direct, Link Direct - SQL Server 2008 - Link Direct Usually concealed as the last layer in all software architecture, the database is the core of any web ...

Link Direct Download, ... - linkdirects.net

5 days ago by Sandesh Segu

In one of my previous posts " Undocumented stored procedure for retrieving SQL Agent properties", I had explained how to retrieve the SQL Agent Properties. In this post I will explain how to change the location of the SQL Agent Log file "SQLAGENT.OUT". To find the current location of SQLAGENT.OUT fi ...

Sans SQL - sanssql.com

5 days ago by Steinar

Did you ever think that it would be great to cache SQL Server database query results, and only go back to query the database when data has changed? Well, you can do that, using Query Notifications. Query notifications…

SQL Service - ... - sqlservice.se · 2 references

5 days ago by Uygar

If you delete one of your databases this could affect your database user's login. You can suddenly get "Cannot Open User Default Database (error 4064)" error message. You must change the default database for the user: alter login the_user_giving_error with default_database = another_valid_database I ...

Uygarca - uygarca.com

6 days ago by kkryczka

SQL Server: slice table data evenly into a specified number of segments The following query simply counts the rows in the table and slices the table evenly into a specified number of segments: select a.* from tableA a, ( select RowNumber = ROW_NUMBER() OVER (ORDER BY ID ASC) , b.* FROM tableA b [... ...

Activator.... - kkryczka.wordpress.com · 1 reference

7 days ago by Sandesh Segu

There might be a situation where a person designed a database with a particular datatype for many tables and now you want to change the datatype to a different one for all those columns in a particular table or multiple tables due to various reasons. Changing the datatype for a single table or five ...

Sans SQL - sanssql.com

7 days ago by W and D

Estaria quem sabe buscando uma certificação Microsoft. Uma certificação Windows 7, Exame: 70: 680. Quem sabe talvez, uma instalação e … Continuar lendo »

W and D - cssti.wordpress.com · Rank: 34,626 · 3 references

9 days ago by Jugal Shah

Execute below query to get TOP 25 completed queries which have the highest cumulative CPU usage SELECT highest_cpu_queries.plan_handle, (highest_cpu_queries.total_worker_time/highest_cpu_queries.execution_count) AS AverageCPU, highest_cpu_queries.execution_count, highest_cpu_queries.total_worker_tim ...

SQLDBPOOL.COM - sqldbpool.com · 21 references

9 days ago by Jugal Shah

If you will try to insert the value into Identity column you will get the one of the below error. Error 1: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table ‘Employee’ when IDENTITY_INSERT is set to OFF. Error 2: Error 8101 An explicit value for the identit ...

SQLDBPOOL.COM - sqldbpool.com · 21 references