So, if it says that my log file is using 1.06 % of the space should I truncate it?My opinion is NO. Why? If you shrink it and is going to grow again because you will perform the same operations over and over you will be effectivelly fragmenting the file with shrinks and grows. The one […]
2005-01-20
While this will work, note that xp_dirtree is undocumented. You can achieve the same result, if you pipe the result from a simple xp_cmdshell DIR... into a table like so:create table #temp( [name] varchar(100)) DECLARE @sql varchar(100) SET @sql = 'DIR C:\ /b/a-d-s' INSERT INTO #temp EXEC master.dbo.xp_cmdshell @sql SELECT COUNT(*) FROM #temp WHERE name […]
2005-01-20
At the end of this thread you can find the code to detect if a job is running or not and all you will have to code after that is someting likeexec sp_startJob ...DECLARE @job_name sysname, @status tinyintWHILE 1=1 beginEXEC DBA..af_Job_Status 'YourJobName', @Status OUTPUTIF @Status <> 0 --Not Done Wait for '00:00:01' --1s ELSE […]
2005-01-20
I've been having full text indexing problems on our sandbox database, so I figured I'd just start from scratch. I uninstalled SQL Server. No prob. As I'm re-installing, I get to the "instance" screen and the default checkbox is greyed out (disabled). It's forcing me to create a named instance. I don't want this. I […]
2005-01-19
54 reads
mmmm sorry but i have done some prooves and it doesnt happen how you say.I have altered a table by enterprise manager and then i look into the SysObjectand there is no a second entry only one, Why? does my sqlserver need a special configuration? thanks
2005-01-19
I am using a transform data task to migrate data from one table to another. Is there a way to capture between each insert statement the last identity column value of the table? Between each insert I need to populate another table with the last identity column value. I tried searching the forums for an answer […]
2005-01-19
Morning Guys 'n Gals,Hope someone can point me in the right direction:I keep getting a NaN error when I run my report in Reporting Services.Does anyone know of a way to replace the NaN with "---" in my report??Many Thanks Munish
2005-01-17
18 reads
If the data is so valuable that no one should be able to browse it, it should be encrypted.If you don't want DBA's to be able to select data from the table, don't make them sysadmins. Give DBA's restricted access to the database, and follow some strict security guidelines for the SA account. (Change password […]
2005-01-13
Comments posted to this topic are about the Question of the Day for 24 Mar 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=438.
2005-01-13
Comments posted to this topic are about the Question of the Day for 22 Feb 2005 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=437.
2005-01-13
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers