Viewing 15 posts - 1,606 through 1,620 (of 2,462 total)
You can get the schema, name and DDL for the stored procs from INFORMATION_SCHEMA.ROUTINES. Something like this...
DECLARE @buildSprocsScript nvarchar(max) ='';
SELECT @buildSprocsScript += 'DROP PROC '+specific_schema+'.'+specific_name+char(13)+'GO'+char(13)
+REPLACE(ROUTINE_DEFINITION,'<what you want to replace>','<replace...
-- Itzik Ben-Gan 2001
April 16, 2015 at 10:48 am
GilaMonster (4/13/2015)
Alan.B (4/10/2015)
-- Itzik Ben-Gan 2001
April 16, 2015 at 9:57 am
The book you listed is not a bad start at all. I actually own it but have not read it; as a DBA, however, I learned a ton from the...
-- Itzik Ben-Gan 2001
April 16, 2015 at 9:47 am
Ok, quick update... I did some research on this - it appears that sys.partitions does not guarantee an accurate row count. According to Microsoft, the rows column in sys.partitions "Indicates...
-- Itzik Ben-Gan 2001
April 10, 2015 at 4:26 pm
Sean - I am interested in why you say that COUNT(*) is the only way to get a row count. I'm not disagreeing with you - just curious looking for...
-- Itzik Ben-Gan 2001
April 10, 2015 at 3:36 pm
Could you perhaps include a little DDL, sample data and an example of expected output?
-- Itzik Ben-Gan 2001
April 10, 2015 at 2:51 pm
Have you tried http://<your actual server name>/Reports ? I think I have seen this in the past and, for some reason, localhost was not working.
-- Itzik Ben-Gan 2001
April 10, 2015 at 2:47 pm
Thank you Grant and Jeff!
-- Itzik Ben-Gan 2001
April 10, 2015 at 8:01 am
I don't fully understand what you are trying to do but the splitter referenced in my signature line is the best way to split a string. This should get you...
-- Itzik Ben-Gan 2001
April 9, 2015 at 2:33 pm
This is a loaded topic. A few thoughts....
Get your disk configuration right. It's nice to split up your IO between different physical disks; such as:
C: OS Files
D: Program File/SQL Install
E:...
-- Itzik Ben-Gan 2001
April 9, 2015 at 12:47 pm
I have run into this before too. Note this thread on stackoverflow: RAISERROR issue since migration to SQL Server 2012
-- Itzik Ben-Gan 2001
April 9, 2015 at 11:15 am
Below are a couple functions that I am working on that will get you the queries that are creating the most CPU pressure and IO pressure.
These are based on...
-- Itzik Ben-Gan 2001
April 9, 2015 at 10:41 am
This does fall into the category of Log Backups which Grant mentioned..
I would expand it to Log File maintenance. This includes changing the recovery model to Simple for Databases...
-- Itzik Ben-Gan 2001
April 9, 2015 at 9:53 am
Excellent article. 5 stars from me. I have not seen an article that discusses the new 2014 Cardinality Estimator in such detail. Well done sir!
-- Itzik Ben-Gan 2001
April 9, 2015 at 8:36 am
Thanks!
I actually had a few moments to kill and optimized that query further; this will be much, much faster, uses less code and creates a simplified query plan...
DECLARE @xml...
-- Itzik Ben-Gan 2001
April 8, 2015 at 2:31 pm
Viewing 15 posts - 1,606 through 1,620 (of 2,462 total)