http://datarealized.wordpress.com/

http://datarealized.wordpress.com/
Name: http://datarealized.wordpress.com/
Score: 97.01
Last Seen: 366 days, 22 hours, 45 minutes ago
Member Since: 27 July, 2009
SqlServerKudos
atom rss
2
kudos
spam Kudos Remove

Celko's Summer SQL Stumpers: Prime numbers
published 368 days, 7 hours, 53 minutes ago posted by sasa 368 days, 23 hours, 35 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Monday, July 27, 2009 8:23:07 PM GMT
Celko's Summer SQL Stumpers: Prime numbers
I was teaching SQL classes for YAPC-10 (“Yet Another PERL Conference” #10) at Carnegie Mellon University at the end of June 2009. For the record, I have never used PERL and had to Google up an overview before I went; it is a very different creature from SQL. One of my students asked if you could write an SQL statement to generate the prime numbers less than 1000 (or any other limit) that scales well. He was bothered by the lack of loops in SQL and a Prime Number sieve is a common PERL programming ... (more)
category: Query | clicked: 0 | comment | | source: www.sqlservercentral.com
tags: Puzzle
2
kudos
spam Kudos Remove

The effects of DISTINCT in a SQL query
published 368 days, 7 hours, 53 minutes ago posted by sasa 370 days, 13 hours, 27 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Sunday, July 26, 2009 6:31:46 AM GMT
The effects of DISTINCT in a SQL query
Earlier today, I had a great Twitter conversation with Tim Mitchell (@Tim_Mitchell), Jorge Segarra (@SQLChicken), and Jack Corbett (@unclebiguns) about the use of DISTINCT in a SQL Server query. By the way, this is yet another example of how Twitter can be used in a good and positive way within the work environment and within the SQL Server Community; Twitter is not just a time sink that squeezes productivity out of your day as some claim. Many people (not those mentioned previously) resort to using the... (more)
category: Query | clicked: 4 | comment | | source: webbtechsolutions.com
tags: DISTINCT
2
kudos
spam Kudos Remove

Looking for security vulnerabilities in database code
published 368 days, 7 hours, 53 minutes ago posted by sasa 370 days, 13 hours, 21 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Sunday, July 26, 2009 6:37:29 AM GMT
Looking for security vulnerabilities in database code
I've always been concerned with security and I've always stressed the importance of auditing the REAL user context not just the current user (see this post on EXECUTE AS and auditing). So, I generally try to avoid using dynamic string execution and if necessary create well tested/protected parameters (fyi - using QUOTENAME can be a fantasic solution to protectng identifiers as input paramet... (more)
category: Security | clicked: 1 | comment | | source: www.sqlskills.com
tags: Security, SQL Server 2005, SQL Server 2008
2
kudos
spam Kudos Remove

SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
published 366 days, 7 hours, 51 minutes ago posted by http://sqlchicken.blogspot.com/http://sqlchicken.blogspot.com/ 369 days, 4 hours, 36 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:22:08 PM GMT
SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
This morning on Twitter my friend (and as per request, “handsome moron”, but trust me he’s no moron) Jeremiah Peschka (Twitter) asked about scheduled traces. I suggested he do a server-side trace. Unfortunately when you Google how to do this it just tells you how to do this via T-SQL but to my dismay I didn’t see an article on how to create/set this up from SQL Server Profiler. So this will be a quick rundown on how to create your trace using the GUI of SQL Server Profiler and schedule your trace to run ... (more)
category: Management | clicked: 2 | comment | | source: sqlchicken.blogspot.com
tags: Administration, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
published 365 days, 7 hours, 47 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 369 days, 4 hours, 1 minute ago
Friday, July 31, 2009 12:11:33 PM GMT Monday, July 27, 2009 3:57:49 PM GMT
Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
I realize that there are some cases where, in an emergency, you need to shrink a log file because it took over the drive.  In SQL Server 2005 and earlier, you could get out of the jam quickly, by issuing a BACKUP LOG WITH TRUNCATE_ONLY (followed by DBCC SHRINKFILE).  In SQL Server 2008, this "feature" within BACKUP LOG is no longer available, and with good reason; however, there are other - shall we say, "clever" - ways to achieve this.  But too many people pass this advice off casually, and this gives p... (more)
category: Management | clicked: 3 | comment | | source: sqlblog.com
tags: LogFile, LOGS, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes
published 366 days, 7 hours, 51 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 369 days, 4 hours, 17 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:41:35 PM GMT
The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes
This is one of those topics I planned to blog about a long time ago, but never actually got around to it, and consequently I keep having to hit search engines to find the code I provided in a forums post when I need to use it again.  A while back, I helped fellow SQL enthusiast Jeremiah Peschka (@peschkaj) out via twitter with finding plans that included missing index information in them.  Then a bit later I used the same code on a Forums Post and then again with Michelle Ufford (@sqlfool) who actually t... (more)
category: Analysis | clicked: 0 | comment | | source: sqlblog.com
tags: analysis, Performance, plan cache, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

Move non clustered indexes to a new filegroup « Data Realized – The Blog
published 366 days, 7 hours, 51 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 369 days, 4 hours, 23 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:35:22 PM GMT
Move non clustered indexes to a new filegroup « Data Realized – The Blog
So, over the years I have needed to move an index or a set of indexes to a new or different file group. I’ve written scripts for this in the past and lost them along the way and I couldn’t find anything out there on the bing or google interwebs. The concept of multiple files and file groups for a database is beginning to sink in with a lot of developers and dba’s. The rationale for using them is typically sound and in my experience it’s one of wanting to decrease the internal file fragmentation of the d... (more)
category: Analysis | clicked: 9 | comment | | source: datarealized.wordpress.com
tags: file groups, index management, SQL Server 2005