Search results for query: *

Hi, ver 2005 1.) What does it mean when it shows a job executed successfully at such and such time, but there is no history under "view history" ? 2.) Is there a reason that an "EXEC (mySQLStmt)" would not run from a stored procedure that is called from a job? That is, if I run the "EXEC...

Hi, I just wanted to get a "consensus" about this issue. Our company recently moved its datacenter out of state. We are now using SAN technology for all of our data files and backups... that is, everything now resides on the SAN disk array - files and backups. To date, we have no mechanism in...

Hi, I am examining the weekly index defrag report... I run DBCC REINDEX on a weekly basis on indexes that are fragmented. This is weird. One of the indexes that was reindexed was an index on a numeric ID field - it's a nonclustered, unique, primary key index - don't ask me why this is a...

Hi, I have a weekly job that examines the index fragmentation of all tables in a given database. If the index fragmentation reaches a certain threshhold, then it runs DBCC DBREINDEX against the table, with a fillfactor of 75 (the decision to use 75 was somewhat arbitrary on my part). However...

Hi, Just want to get a reality check here. Prior to our company getting bought out, I had a pretty decent manager. Despite a few annoying idiosyncracies (like talking too much!), he was bright and energetic, and actually very helpful at times. I also had a pretty good relationship to his boss...

Hi, I have been at my present company for about a year and half. Before this job, I had been out of the IT loop for about 4 years due to living on a beautiful tropical island with no IT jobs :-) That said, I was eager to return to IT, and a real paycheck. My previous career had been as an...

Hi, As may or may not be evident from my posts, I have been contemplating a job move for some time now. Basically my question is, is it reasonable to look for a job where I can strictly do SQL Server development work? It seems that so many shops these days have their regular programmers writing...

Hi, I have been tasked with creating some reports, that will be viewed on a weekly basis, meaning the data for the reports only needs to be updated once a week. Basically my question is, is my approach correct. I don't want to run queries against live data, so the idea is to create separate...

Hi, Is there a system table or sp that I can use to determine if any SCHEMA (ddl) changes have occurred in any tables in a given database?? Thank you

SQL Server 2005 Someone here attempted to update about 3000 rows in a table that is in replication (on the publisher side). We are using push replication. The rows were updated successfully on the publisher table, but for some reason, it seriously locked up the replicated table on the...

Hi, Here's my deal. I have a customers table, and newly created table MSA data table. The MSA (metropolitan statistical area) table contains a lot of statistical information, including zip codes and for each zip code, a related MSA name. However, not all zip codes have a corresponding MSA name...

Hi, Using this as an example: SELECT c1, c4 FROM myTable WHERE c1 = 1 and c2 = 2 and c3 = 3 ORDER BY c1 I created a clustered index on c1, c2, and c3 initially Then I dropped that index and created a clustered index on c1 ONLY (c1 being the most selective column, but not unique) and the...

Hi, I have been tasked with a very aggravating project. Someone from our headquarters wants a report of how many customers per "Metropolitation Statistical Area" (MSA) we have in our database. See http://www.census.gov/population/estimates/metro_general/List4.txt for the complete list of...

Help. SQL Server 2005 I imported an Excel spreadsheet to a table using the Import tool. One of the fields in the spreadsheet was phone number. No big deal. I looked at the imported table, and the phone number field appears correctly, eg) 5055551234 However, I then had to copy the...

I am taking a survey. What are good skills for a SQL Server developer to have outside of SQL Server? Or even "inside" SQL Server, that goes above and beyond the "normal" day to day requirements? I am just wondering because I have a little free time on my hands this week and would like to brush...

Hi all, I have some questions about table variables vs. temp tables. 1.) Under what conditions would you chose one or the other? 2.) Is one faster than the other? 3.) Is this a valid replacement for using cursors? Thanks much

Hi, I was wondering if someone had any suggestions as to how to make this work without a cursor. Thanks much create TRIGGER [tgr_ExportHomesExceptionsHistory] ON [dbo].[ExportHomesExceptions] FOR DELETE, UPDATE AS BEGIN SET NOCOUNT ON; DECLARE @HomeIdDeleted int DECLARE...

Hi, Here's my question. How do I script out the CREATE syntax for a table, NOT using Management Studio. That is, I would like a SQL method of scripting the table out, much like what is provided by the "sp_helptext" function for scripting out stored procedures and triggers. The output would look...

Hi, Is it possible to write the output of "sp_helptext" command to a file from SQL Server 2005? I was thinking of using a stored procedure to do this. If so, how can I do this? Thanks much

Hi, I am using db mail. I would like the body portion to have carriage returns, such as: BEGIN EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Administrator', @recipients = 'me@yahoo.com', @subject = 'FAILED JOB, @body = 'Restart attempted...' + [carriage return here] + 'please check job status'...