How to use performSelector:onThread:withObject:waitUntilDone:? here in onthread i have to use other thread not main thread. How to create other thread? give me some sample code.
On 25th Feb we launched the first ever giveaway of PDF Converter Elite for Tech Dreams viewers and thanks for everyone who participated in the content. We are happy to see good response from our viewers and special thanks to all those who shared our stories on Facebook and Twitter. Here are the lucky winners
Avikchatterjee …
There is a famous quote about unknown unknowns and known knowns and so on but I’ll let you review that if you are interested.
What I am worried about is that there are things going on in your environment that you ought to know about, indeed you have asked to be told about but you are not getting the information.
When you schedule a SQL Agent…
Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database…
Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL Backup will be a REAL boost to any DBA lucky…
You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can…
Find out what SQL Source Control & SQL Compare can do for your database development and deployment processes at one of our free weekly webinars. Each webinar includes a 30 minute software demonstration and a Q&A session.
The Future of SQL Server Monitoring "Being web-based, SQL Monitor enables you to…
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL Backup will be a REAL boost to any DBA lucky…
Auf dem OPN
Day Satellite in Frankfurt haben wir unter allen Fans des Facebook-Profils
von Oracle Alliances & Channel Deutschland ein iPad 2 verlost: Wer bis zum 8. November 2011, 16 Uhr den "Gefällt mir"-Button angeklickt hatte, nahm an unserer Verlsung teil. Und..... der glückliche Gewinner ist: Markus Meyer vom…
Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation.
The Future of SQL Server Monitoring "Being…
Wesley has heard High Availablity touted as all sorts of technological cure-all for busy SysAdmins and DBAs, and now he's taking a stand against it. There are a range of things that High Availability is regularly confused with (either deliberately or innocently), and Wesley's clearing it all up
…
Using ANTS Performance Profiler with SharePoint has, previously, been possible, but not easy. Version 5.2 of ANTS Performance Profiler changes all that, and Chris Allen has put together a straight-forward guide to profiling SharePoint, demonstrating just how much easier it has become.
Every time I attend a SQL Saturday , I leave with a rejuvenated and even further reinforced sense of community. Cleveland ( SQL Saturday #60 ) was by far no exception. Allen White ( blog | twitter ), Erin Stellato ( blog | twitter ), Cory Stevenson, Brian Davis ( twitter ), and all others involved put on a…
A disruptive innovation raises an old, old question.
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL Backup will be a REAL boost to any DBA lucky enough
to use it." Jonathan Allen.
Download a free trial now.
The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.
The Future of SQL Server Monitoring "Being web-based,…
Google+ Platform Office Hours for February 1st 2012
Jenny Murphy and Jonathan Beri represented Google. Fraser Cain, Abraham Williams and Allen Firstenberg joined us from the developer community. This week we discussed the new configuration options for the Google+ Badge. You can read more about these…
In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.
The Future of SQL Server Monitoring "Being web-based, SQL Monitor enables…
The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore
The Future of SQL Server Monitoring "Being web-based, SQL…
Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL Backup…
Seit dem 12. Oktober 2012 steht APEX 4.2 zum Download bereit. Nach der Installation, die wie immer, mit dem Skript apexins
durchgeführt wird, können Sie gleich mit dem Ausprobieren der neuen
Features beginnen - allen voran das einfache, deklarative Erstellen von APEX-Anwendungen für mobile…
A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made.
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL Backup will…
The main goal of this article is to present some tips to help professionals that need to work with complex, big, and hard to understand database models that anyone may came across some day.
Join SQL Backup’s 35,000+ customers to compress
and strengthen your backups
"SQL…
Every time I attend a SQL Saturday , I leave with a rejuvenated and even further reinforced sense of community. Cleveland ( SQL Saturday #60 ) was by far no exception. Allen White ( blog | twitter ), Erin Stellato ( blog | twitter ), Cory Stevenson, Brian Davis ( twitter ), and all others…
I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users…
From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary…