July « 2009 « SQL Server Journey with SQL Authority

Archive for July, 2009

SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing

Posted in Pinal Dave, SQL, SQL Authority, SQL Azure, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged Cloud Computing on July 21, 2009 | 2 Comments »

Microsoft has updated the branding for SQL Services and SQL Data Services. SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database. Changing the name does not change product but it demonstrates tight integration between the components of the service platforms. As a part of the Windows [...]

Read Full Post »

SQLAuthority News – Authors Visit – DelhiBuzz TechEd on July 11, 2009

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on July 20, 2009 | 1 Comment »

SQLBuzzDelhi organized TechEd Delhi on July 11, 2009. They even launched an official PASS Chapter in Delhi. The complete report of this event is here. This event like TechEd in Ahmedabad, was a huge success and saw a huge number of attendees from all over India. Jacob Sebastian and Pinal Dave had presented two solid [...]

Read Full Post »

SQL SERVER – Get Last Running Query Based on SPID

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Server DBCC, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology on July 19, 2009 | 21 Comments »

We often need to find the last running query or based on SPID need to know which query was executed. SPID is returns sessions ID of the current user process. The acronym SPID comes from the name of its earlier version, Server Process ID. To know which sessions are running currently, run the following command: [...]

Read Full Post »

SQLAuthority News – Whitepaper – Using the Resource Governor

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on July 18, 2009 | 2 Comments »

Using the Resource Governor SQL Server Technical Article Writer: Aaron Bertrand, Boris Baryshnikov Technical Reviewers: Louis Davidson, Mark Pohto, Jay (In-Jerng) Choe Published: June 2009 SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources [...]

Read Full Post »

SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database

Posted in Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on July 17, 2009 | 9 Comments »

There are two different methods of retrieving the list of Primary Keys and Foreign Keys from database. Method 1: INFORMATION_SCHEMA SELECT DISTINCT Constraint_Name AS [Constraint], Table_Schema AS [Schema], Table_Name AS [TableName] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE GO Method 2: sys.objects SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint, SCHEMA_NAME(schema_id) AS SchemaName, OBJECT_NAME(parent_object_id) AS TableName, type_desc AS ConstraintType FROM sys.objects WHERE type_desc IN [...]

Read Full Post »

« Newer Posts - Older Posts »