Yes, BI Documenter is an amazing tool. I say that not just because I work at Pragmatic Works. You can download a trial version at...
595
Ed Watson
gog8rs
Aug 16, 2011 7:19 pm
Is there a meeting tonight? No e-mail...website very vague.
Ed Watson
Application Systems Administrator, MCTS
Information Resources Department
Southwest...
596
Travis Page
dvmtthws9
Aug 16, 2011 7:21 pm
The meeting for August has been cancelled. Pam sent out an e-mail on Monday, its possible you got overlooked. Travis Page ... The meeting for August has been...
597
Pam Shaw
pshaw1129
Aug 16, 2011 7:31 pm
I sent out a cancellation - I will update the site. Medical issues and work along with no meeting space caused too much this month. To:...
598
Jorge Segarra
sqlchicken
Nov 9, 2011 8:35 pm
Sent from my phone, please excuse brevity and typos Begin forwarded message: *From:* "Sharon Dooley" <sharond@...> *Date:* November 8, 2011 7:02:31 AM...
599
Jim Pennington
sunstarems
Dec 22, 2011 2:33 pm
All, I'm not having any issues with this database in production, but I was testing out some different methods of backup and restores and during the testing I...
600
Jose Chinchilla
joseraulchin...
Dec 23, 2011 4:52 pm
Seems like you have corrupt pages on your index. It the backup came from a production db, the data allocated in this corrupt index pages may be excluded when...
601
Jim Pennington
sunstarems
Dec 23, 2011 5:12 pm
Thanks for the help, I just found out the issue is a bug in SQL 2005 and was fixed in SP4, I was running SP3. I just upgraded to SP4 and rebuilt the indexes...
602
Good, Mike
mikegood10
Dec 23, 2011 5:14 pm
That's good to know. Thanks for updating us all w/final resolution. From: tampasql@yahoogroups.com [mailto:tampasql@yahoogroups.com] On Behalf Of Jim...
603
Jay
jason_carter80
Jan 5, 2012 2:04 pm
Our company is looking for a new DBA. Our current guy has done a fantastic job of getting us in a proper setup, but it was not his long term intentions to...
604
Jim Pennington
sunstarems
Jan 24, 2012 3:16 pm
Group, I have a db which is about 600GB (SQL2005) and I want to move the SQL tempdb and log file to a partition of about 100GB. Will I run into any issues when...
605
Jonathan Kehayias
jkehayia
Jan 24, 2012 5:12 pm
Hey Jim, It depends on the size of the indexes, whether sort in tempdb is used, whether it is an online operation, whether you have row versioning in use, and...
606
Jose Chinchilla
joseraulchin...
Jan 31, 2012 4:26 am
Hi guys,I normally don't flood this distribution list with job offers but I wanted to let you know that I came across a couple permanent jobs for immediate...
607
Jun Sato
junsato@...
Jan 31, 2012 3:49 pm
Hello all, Just wanted to get group opinion on something - is it safe to rely on short circuiting in IF's and CASE WHEN's? i.e. let's say I have something...
608
Jonathan Kehayias
jkehayia
Jan 31, 2012 4:48 pm
For the example you provided using a CASE statement and a single variable, it works, but not against a table: DECLARE @MyTable TABLE (RowID INT IDENTITY...
609
Good, Mike
mikegood10
Jan 31, 2012 4:50 pm
PS - I would not rely on isnumeric() for this, it is definitely not a validation that string can be cast as int. Instead use NOT LIKE '%[^0-9]% or something...
610
Jun Sato
junsato@...
Jan 31, 2012 6:37 pm
Thanks all, It makes sense about the behavior with table vs variables. Also - g ood point on ISNUMERIC() as it catches strings like '$10,542.03' as a valid...
611
Jeffrey Garbus
jeff_garbus
Feb 3, 2012 3:12 am
I always test that out when I care; try the query, and see if you get any I/O. No I/O, short circuit worked. (SQL Server Usually gets it right) Have a great...
612
Jonathan Kehayias
jkehayia
Feb 3, 2012 3:58 am
Hey Jeff, The problem is the situations where SQL doesn't get it right, especially for builtin functions like ISNUMERIC() as Mike pointed out and more complex ...
613
Nathan Heaivilin
heaivilin
Feb 6, 2012 5:01 pm
Hey everyone, need some help here. We have 2 servers. Server A and Server B. These 2 servers are setup in a automatic failover H.A. mirroring configuration...
614
Jonathan Kehayias
jkehayia
Feb 6, 2012 5:27 pm
How did you create the jobs exactly? Did you create the job on one server, and then script it out, and then use that script on the other server? I've seen...
615
Nathan Heaivilin
heaivilin
Feb 6, 2012 5:43 pm
Johnathan, How can I confirm this? I did script it from Server A to Server B for my test. Not sure on the original job scripting. Recreating the script I don't...
616
Nathan Heaivilin
heaivilin
Feb 6, 2012 5:47 pm
Quick update. I found sp_help_jobserver and ran it against my test job. The server_name column that is being populated shows the local server, or the server...
617
Travis Page
dvmtthws9
Apr 26, 2012 12:47 pm
Has anyone seen an issue like this come up before? I have a server (SQL Server 2008 R2, 10.50.1600) which has several jobs that have had the owner of a job...
618
Steven W.
imcorporate@...
Apr 26, 2012 8:37 pm
How was the owner information updated? If the table was manually updated using an UPDATE statement, it could produce inconsistent results. I tested this in...
619
sqlsammi
May 19, 2012 6:02 pm
Live SQL Security Webinar @ Your Desk: Protect your sensitive information using Real-Time Dynamic Data Masking When? Wednesday, May 23, 2012 (9:00 am PDT;...
620
sqlsammi
Jun 4, 2012 8:17 pm
Thought this white paper may interest people working in the db security side of things. http://bit.ly/LhZSEU Securosis reports on Database Security Platforms...
621
sqlsammi
Sep 8, 2012 7:55 pm
It's here, live, and ready for download! We have just launched GreenSQL 2.2 which supports Microsoft SQL 2012 and Microsoft SQL Azure cloud service. Our new...
622
sqlsammi
Sep 25, 2012 11:47 am
I thought this might interest someone. Webinar: Learn how to secure Windows Azure SQL databases Date: Oct 4 Cost: Free Presented by GreenSQL Sign-up today!...
623
Garry McGibbon
swamprider5
Dec 19, 2012 3:20 pm
Has anyone seen this error (windows system log) on a server after install of SQL2012: The Windows Modules Installer service terminated with the following...
