Reputation
4,729
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 46 90
Impact
~604k people reached

  • 0 posts edited
  • 6 helpful flags
  • 841 votes cast
Aug
20
comment Is there a DBMS that allows the “= NULL” syntax?
The old sysbase style syntax is more readable in constructs like where x in (null, 1, 2) which you have to rewrite as where y is null or x in (1, 2). BTW even ANSI isn't stringent about NULL can't be equal to NULL. Just see how it handles GROUP BY. I really liked the old syntax, but I abounded fighting against ANSI defaults.
Aug
8
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
A good link is a good start. But I would like to get more information.
Aug
8
comment Which performance counters can you look at on a SQL Server Instance to determine it's performance and over all health?
Is there something at that level to monitor deadlock and waits?
Aug
6
comment How to determine if an Index is required or necessary
Just diving into it. Seems to be the most promising starting point.
Aug
6
comment Does NULL have a type?
+1 For curiosity let's try Select NULL what_type_is_this from DUAL; Of course this no practical useful example and I didn't try it yet, I have learned to use casts in such cases.
Aug
3
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
I see your point, but I don't find that your problem is rather specific, it is the one first problem everyone encounters who has a grown database structure with data entered with relation to time, when thinking about filtered indexes. OK it is possible to ask in different ways.
Aug
2
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
OK. What is the answer to your question? Does the filtered index help or not? I think you better had not accepted an answer which main part is just a link to some Microsoft paper. Now we will have a hard time asking questions about filtered indexes without risking being closed as duplicate.
Aug
2
comment Can filtered indexes help improve queries that are based on a time entered or should this be avoided?
The people who came here don't want to get only pointers to that papers. They and I want independent simple examples to get a feeling where this feature might help. They want to be able to deal with arguments like we do not like spending money in Enterprise Editions, perhaps filtered indexes helps us save the money.
Jul
27
comment Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?
He doesn't tell, what happens when there is a primary key on the identity column and partitions are swapped.
Jul
26
comment How to export a single huge table from SQL Server?
+1 for combination of characters. But you can use them without format files. bcp dbname.dbo.mytable OUT test1.txt -S myserver -U sa -P 1234 -c -r '€\n' -t '€|' -- or bcp "SELECT * FROM dbname.dbo.mytable WHERE xx > 100" queryout bk_test2.txt -S myserver -U sa -P 1234 -c -r '€\n' -t '€|'
Jul
25
comment How to export a single huge table from SQL Server?
The varchar fields can contain any character. How do format files help?
Jul
24
comment How to export a single huge table from SQL Server?
I do not see how a format file could help here
Jul
23
comment Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?
Think twice. Your link shows that a single session doesn't get gapeless values. I can't say that is unexpected. Looking at Foo I saw no gaps in the ids of that table: select max(id) - MIN(id) + 1, COUNT(*) from foo
Jul
19
comment Can I implement a 'gapless' identity column in Oracle?
I think SQL Server identity columns do. But I asked it here dba.stackexchange.com/questions/3948/…
Jul
19
comment Can I implement a 'gapless' identity column in Oracle?
In Oracle I can get rid of the id + 1 self join, as its analytical functions contain lead() and lag(), but that makes the code different for SQL Server and Oracle. And yes this is a problem of the remaining 20%.
Jul
19
comment Can I implement a 'gapless' identity column in Oracle?
I guess you have to do it the other way round, cache more values than you will use in a given case. But how much is that?
Jul
19
comment Can I implement a 'gapless' identity column in Oracle?
In SQL Server I do things like: select * from #tmp t1 join #tmp t2 on t1.id = td2.id + 1.
Jul
11
comment ORA-01502: index or partition of such index is in usable state problem
Perhaps I misinterpreted the preceding sentence: During an Oracle bulk copy, the following constraints are automatically enabled by default:NOT NULL, UNIQUE, PRIMARY KEY (unique-constraints on not-null columns). The problem is that Oracle.DataAccess.Client.OracleBulkCopy contrary to Data.SqlClient.SqlBulkCopy has no BulkCopyOption CheckConstraints, which makes it difficult to use.
Jun
29
comment Can I change the SID of an Oracle database?
+1 But I'm still unsure whether I want to change the DB_NAME too.
Jun
28
comment Recovering from: A transport-level error has occurred when sending the request to the server in SSMS
It seems to depend. If the connection to the server was lost, it goes to the default catalog, if only the connection to the database was lost, it reconnects to this database. (tested on SQL Server 2008)