Top new questions this week:
|
|
The (still online) documentation for MS SQL Server 2005 states that BEGIN...END blocks can be used within CASE when it needs to execute a sequence of statements:
The BEGIN and END statements are used ...
|
|
On three different production servers, the following query against sys.databases:
USE master;
GO
SELECT name
FROM sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb');
Results in this ...
|
|
Given two tables counter and cnt_source defined like this:
create temporary table counter (key bigint, count bigint);
create unique index counter_key_uniq on counter (key);
create temporary table ...
|
|
We encountered an issue with view metadata becoming stale on a readable secondary replica in an AlwaysOn Availability Group. The views on the primary replica worked fine after a fix, but the secondary ...
|
|
I am a newcomer to Stack Exchange who is a beginner self-studying SQL. I need help troubleshooting an issue related to bulk inserting data from CSV files into SQL tables.
Environment:
SQL Express
SQL ...
|
|
On MSSQL (our DB size is 520g), there is one filestore table that holds tons of files. 65-70% of this 520g is sitting in there. So essentially, it's a 200g database with 320g worth of files in this ...
|
|
We have multiple webshops with 500.000+ customers, it sometimes occur data becomes faulty due to a bug or a failed import. We currently fix this by executing queries correcting the data directly on ...
|
Greatest hits from previous weeks:
|
|
I'm in the middle of a database server migration and I can't figure (after googling and searching here) how can I list the database privileges (or all the privileges across the server) on PostgreSQL ...
|
|
I have moved my database from an SQL 2005 to a server with SQL 2008.
I am now trying to create an ODBC Data Source.
I am using "With SQL Server authentication using a login ID and password ...
|
|
When using PostgreSQL v9.1, how do I list all of the schemas using SQL?
I was expecting something along the lines of:
SELECT something FROM pg_blah;
|
|
There are similar questions asked and answered in this network related to the error message given in the question, however this problem is a little different from each.
I have installed oracle 12c in ...
|
|
I'm new to Postgres and trying to migrate our MySQL databases over. In MySQL I can grant SELECT, UPDATE, INSERT, and DELETE privileges on a low privileged user and enable those grants to apply to all ...
|
|
This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this:
In SQL Server -
What are some reasons the transaction log ...
|
|
I'm looking for a precise piece of information in a database which I have no knowledge about. The database is on a separate machine, but I can log into it, and launch a psql command line, with ...
|
Can you answer this question?
|
|
I'm evaluating GridDB Cloud for a high-throughput IoT workload and encountered behavior that I can’t fully explain using the available documentation.
I have a TimeSeries container using default ...
|
