I can do the following: select char(64 + 2) = B select char(64 + 3) = C the result is B. I can put in a number and get the letter in that...
Any thoughts as to books to study for this certification? anyone done it yet? suggestions?
I have a DB that has had dates stored in UTC by an application. My question is how do I convert a HISTORIC UTC date to reflect the datetime locally....
I know I have done this before.. u know the feeling... but I cant recall.. I have a script that will create a bunch of commands. you could run...
I will be at SQL Pass in Seattle Oct 11-15th. If anyone wants to meet and talk shop let me know. I have been part of SQL-Server_performance.com for...
Are we ever going to have a SQL 2008 certification section?:)
Ladies and GentlemenI have an issue I am a bit dumbfounded by...I have a very large table (96,270,560 rows) which performance has been an issue....
If you run Quest Litespeed backups I have the blog post for you!I have a job that I created that uses Database Mail and my Litespeed Central...
I am interested in performance data collection using SQL 2008. Does it require all sources to be from SQL 2008? I read that it can pull from a...
Looking to meet other SQL DBAs for discussion and to make friends while I am there.Anyone want to get together and geek out?Mike
I work for a great company that has great benefits, people and job security. I would recommend this to anyone who loves data and works well with...
Ok guys and gals. I have a question. Been so busy I haven't been on here for a while. Help me and I should have more time to help others:) The...
We switched a large server from 2000 to 2005 and are getting:BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model...
cpu_ticks_in_ms has been removed from sys.dm_os_sys_info Anyone have any idea if there is any other way to pull cpu level information through SQL?
I am trying to run a server side trace based on duration that will exclude rows that are null for that field. If I add this as a filter it does not...
I have a query that pulls 900 K rows (no laughing - this is a vendor app! - ok.. u can laugh at the vendor) when I run the query with "set statistics...
I am working on some policy based management issues where I need to run some tasks across my servers. To do so would require me to create some...
I am looking for a tool that helps make index recommendations automatically by using the new DMVs. I think DTA is great, but having to capture long...
Guys and Gals I have query that takes 30 seconds in Dev/Test/Prod. I added index, updated stats to a heap. It has non-clustered but no clustered...
Separate names with a comma.
