RE: MS SQL Server 2000 vs Oracle
See whether the link http://qa.sqlservercentral.com/columnists/dPriyankara/comparisonofbusinessintelligencestrategiesbetweens.asp is helpful. MCP MCSE MCSD MCDBA
2003-06-24
1 reads
security
RE: Best practice on table design
Hi Tim, quote: But in practice, using variable length columns means that row size will typically be much smaller than the maximum. You need to consider average size rather than maximum size when deciding the issue. good hint, but then you have to make assumption on what there might be in those columns. It can […]
2003-06-24
RE: Best practice on table design
Yes - if your row size means that a lot of space will be left on table pages (e.g. fixed row size of 3KB, * 2 = 6, leaves 2K unusable) then you will swell the database size and slow down table scans to some extent. But in practice, using variable length columns means that […]
2003-06-24
RE: backup failed with opereting system error 1130
I had a similar issue (not with sp3) but it was because someone had changed the actual directory to the default dir eg (\mssql\backup\) as opposed to a drive that was made specifically for backups, which in this case had not enough space. My first suggestion would be to try and backup the databases to […]
2003-06-23
RE: Using "Like" or Wildcard
I don't want ALL active courses. Courses are stored by departments. I want all active courses in department 10 only. Department 10 also has inactive courses. I don't know how to check with the profiler to make sure the correct SQL code is being passed to the SQL Server. Sorry I'm just getting back to […]
2003-06-23
2 reads
RE: Function/Linked Server Problem
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-23
RE: Opinion - Case Join ?
If I understand correctly then something like this could work: In the SELECT list you need to display TaxID or MemberID but not both. Try this: 'ID' = CASE WHEN et.EntityTypeID = 1 THEN MemberID WHEN et.EntityTypeID = 2 THEN TaxID ELSE NULL END The join is different. There are a few ways to do […]
2003-06-23
RE: Auto Shrink - When does the shrink db execute?
One of the problems with Autoshrink is that it will run when you don't want it. Turn AutoShrink off and set up a nightly job to do database maintenance. Patrick
2003-06-23
2 reads
RE: Auto Shrink - When does the shrink db execute?
SQL Server will try to shrink the files when found out that the files has about 25% of free space during its periodic checks (checkpoints). It also reduces the Log files using the Tran Log Backup process. One suggestion though is to set the auto shrink to off. You may want to have more control […]
2003-06-23
1 reads
RE: setting query timeout value for a single statement
thanks... does SET QUERY_GOVERNOR_COST_LIMIT take SECONDS as the supplied value? Just to make sure I'm understanding this correction... does this statement mean "kill the query (i.e. timeout) if the statement takes more than 30 seconds to complete"???: SET QUERY_GOVERNOR_COST_LIMIT 30 thanks, -skip
2003-06-23
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers