Pulse » Recent Items from 12/21/2011

Welcome!

Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.

  • Browse

    Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.

  • Vote

    Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.

  • Comment

    When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.

December

  1. 16
  2. 23
  3. 31
  4. 42
  5. 56
  6. 68
  7. 79
  8. 86
  9. 910
  10. 102
  11. 110
  12. 1211
  13. 1314
  14. 147
  15. 159
  16. 166
  17. 170
  18. 182
  19. 196
  20. 205
  21. 219
  22. 225
  23. 236
  24. 242
  25. 251
  26. 262
  27. 274
  28. 286
  29. 298
  30. 309
  31. 317

21

  1. 12 A0
  2. 10
  3. 20
  4. 30
  5. 41
  6. 50
  7. 60
  8. 70
  9. 80
  10. 91
  11. 101
  12. 110
  13. 12 P2
  14. 10
  15. 22
  16. 30
  17. 41
  18. 50
Home

  1. Sharepoint and PowerPivot: Connections fail to refresh in SQL Server 2008 Denali CTP3

    Sharepoint requires a range of troubleshooting skills because it can involve the integration of various applications, which are necessarily resting on the application stack. I have the deepest respect for SharePoint specialists since i know that the troubleshooting skills can cut across applications and an understanding of the 'glue' that ...

  2. SQL Server 2012 (“Denali”): AlwaysOn

    AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters to help enable fast application failover during planned and unplanned downtime. Specifically, AlwaysOn delivers failover cluster instances, multiple secondaries, active secondaries, and connection director capabilities (multi-subnet and read-only ...

  3. Understanding SOME ANY ALL Operators with examples

    These operators involve a query and a Sub Query. QUERY (CONDITION) SOME|ANY|ALL (SUB QUERY) CONDITION Above would include the following operators = (or) (or) ! = (or) > (or) > = (or)! > (or) SOME Operator: This operator compares the value in the query with the values in the sub ...

  4. Backing up SSRS Encryption Key with Powershell

    A few months back I wrote a post about how I wanted a way to automate a backup of the encryption key used by our SQL 2008 reporting servers. I thought that Powershell would be the way to go, but I ran into a few issues. First, I couldn’t ...

  5. using max aggregate function on varchar column vs int column sql server

    MAX aggregate Function behaves in a different way on numeric columns when compared to alpha-numeric columns. consider the below TSQL script: DECLARE @vTable TABLE (ID INT) INSERT INTO @vTable(ID) SELECT 1 UNION SELECT 199 UNION SELECT 99 SELECT MAX(ID) FROM @vTable We can expect the result of the ...

  6. Windows 7/2008R2 does not load after adding the drive to another machine that also uses new BCD store

    Symptom: When you attach a system (boot) volume in Windows 7/2008 R2 to any other Windows 2008 R2 as another drive you will run into an issue where attach it back without modifying any files on the volume; it becomes non-bootable. It looks alright and it can be attached ...

  7. Operations On All Tables In All Databases in SQL Server using sp_MSforeachdb and sp_MSforeachtable

    Queries that are used to perform various operations on all the tables on all the databases can be simplified by using the Undocumented stored procedures sp_MSforeachdb and sp_MSforeachtable. Combined use of both sp_MSforeachdb and sp_MSforeachtable will make the tasks simpler. Example tsql queries: Note: The below queries ignores system databases ...

  8. sp_MSforeachtable Examples – Uses – InDetail – msdn

    sp_MSforeachtable is an undocumented stored procedure that is not listed in MSDN Books Online. Use:sp_MSforeachtable can be used to run a query against each table in the database. Examples: Updating statestics for each table in the database Logging the space used by each table in the database finding the ...

Home

Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.