sql.richarddouglas.co.uk

sqlsolace.blogspot.com

sql solace: Dev 101

http://sqlsolace.blogspot.com/p/most-referenced-tsql.html

SET STATISTICS TIME ON;. SET STATISTICS IO ON;. While loop and table variable. Error Handling - TRY / CATCH. Instant Messages in Management Studio. RAISERROR ('my message', 10, 1) WITH. While loop for Incremental (nibble) DELETE / UPDATE. Conditional WHERE, LIKE, ORDER BY using CASE. SSIS 2008 / SQL 2008 / .NET. Date from datetime -. V1 - DATEADD(dd, DATEDIFF(dd,0,GETDATE() , 0). V2 - SELECT CAST(DATEDIFF(D, 0, GETDATE() AS DATETIME). Date formatting - SELECT CONVERT(VARCHAR(30),GETDATE(),21).

sqlsolace.blogspot.com

sql solace: October 2014

http://sqlsolace.blogspot.com/2014_10_01_archive.html

Wednesday, October 15, 2014. A Truly Random Post. Want to generate a truly random number? It's a little more tricky than it first seems. First off, TSQL has a RAND. Function. Simple huh? Not so fast. We'll start with some definitions. Returns a pseudo-random value of the float datatype from 0 through 1, exclusive. The value returned is based on the seed, hence providing the same seed always produces the same values. It is difficult to use RAND. In set based results as it is only evaluated once per batch.

codegumbo.com

codegumbo » #TSQL2sDay T-SQL Tuesday 23–Early edition

http://codegumbo.com/index.php/2011/09/27/tsql2sday-t-sql-tuesday-23early-edition

Laissez Les Bon Code Roulez! TSQL2sDay T-SQL Tuesday 23–Early edition. Time once again for another edition of T-SQL Tuesday! 160; What’s that, you say? 160; Why yes, indeed.  Due to the potential schedule of conflict of PASS’s Summit 2011 occurring on the second Tuesday of October (the normal date for T-SQL Tuesday), I’ve gotten special permission to bump it up a week. . Do me a favor, though, and please spread the word about the early date.  Looking forward to reading your submissions. September 27, 2011.

sqlsouthwest.co.uk

d_a_green | SQL South West

https://sqlsouthwest.co.uk/author/daveagreen

User Group for SQL Server professionals in the South West. Training Day session details. Where is SQL Saturday Exeter? Author Archives: d a green. About d a green. November meeting 9th November 2015. John Martin ( b. John is a Sales Engineer for SQL Sentry, interacting with existing and prospective customers at conferences and trade shows. He also provides demos and online webinars for existing and future users of SQL Sentry software. Building and Configuring SQL Server : Recommended Practices. When plan...

bradmcgehee.com

At the End of One Chapter and the Beginning of a New Chapter | Brad M McGehee

https://bradmcgehee.com/2012/08/15/at-the-end-of-one-chapter-and-the-beginning-of-a-new-chapter

At the End of One Chapter and the Beginning of a New Chapter. August 15, 2012. I have been told by hundreds of DBAs that I have the best DBA job in the world as Director of DBA Education for Red Gate Software. In addition to writing and editing articles for Simple-Talk.com. In my time with Red Gate, I have worked with many great co-workers. While I don’t have room to mention all of them now, I want to give special thanks to Steve Jones. I also want to thank all of the user group leaders, and conference c...

sqlsolace.blogspot.com

sql solace: Calculators

http://sqlsolace.blogspot.com/p/byte-calculator.html

1 Byte = 8 Bit. 1 Kilobyte (KB) = 1024 Bytes. 1 Megabyte (MB) = 1048576 Bytes. 1 Gigabyte (GB) = 1073741824 Bytes. 1 Terabyte (TB) = 1099511627776 Bytes. Subscribe to: Posts (Atom). CTE to create a sequence of numbers. Simple template. Powered by Blogger.

sqlsolace.blogspot.com

sql solace: SSRS

http://sqlsolace.blogspot.com/p/ssrs.html

Dynamically Changing Cell Colour. Solace : Reporting Services 2005 : Installing IIS on Windows 2008. Solace : Reporting Services 2005 : Installing 32bit version on a 64bit server. Subscribe to: Posts (Atom). CTE to create a sequence of numbers. Simple template. Powered by Blogger.

sqlsolace.blogspot.com

sql solace: Investigating a (suddenly) slow running query...

http://sqlsolace.blogspot.com/2015/05/investigating-suddenly-slow-running.html

Thursday, May 28, 2015. Investigating a (suddenly) slow running query. Some Questions / lines of enquiry . What else was going on on the server at that time? Is another process monopolising resources (memory, cpu, i/o). Any change in data volume (influx of new data). Is all maintenance happening? It won't take long to check). Are statistics up to date. How is index fragmentation. Are backups occurring (remember full backups control log fie growth). Can the query be run manually? Look at Execution plan.

sqlsolace.blogspot.com

sql solace: Plan Cache Pollution

http://sqlsolace.blogspot.com/2015/05/plan-cache-pollution.html

Thursday, May 28, 2015. They say if you can't explain something easily, you don't understand it well enough. For that reason, I'm revisiting some things I take for granted. The Plan Cache is where SQL Server stores exection plans. If queries are not parameterized, the plan cache fills with lots of similar queries of hard coded values. SELECT mycolumns FROM mytable WHERE myid = 1. SELECT mycolumns FROM mytable WHERE myid = 2. SELECT mycolumns FROM mytable WHERE myid = 3. Subscribe to: Post Comments (Atom).