Stack Overflow
Stack Overflow

Questions tagged [adhoc-queries]

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which is predefine and performed routinely.

39 questions
1
vote
1 answer

Ad-hoc capability SQL SSRS

We are in the process of doing techincal design. We would like to know what is the Ad-hoc Capability part of SSRS. We have done some POC with Report Model and building reports with Report builder. Options 2 : Build Analysis Services Universe and…
user171523
  • 4,185
  • 3
  • 35
  • 50
1
vote
1 answer

Anyone know of a method / tool to compare ad hoc SQL queries?

I have to convert a lot of legacy SQL queries to stored procs (rewriting and tidying) and I'm looking for an efficient way to compare the results one by one to ensure I haven't modified the behaviour. I currently use SQLDelta but it requires me to…
Ray
  • 3,468
  • 8
  • 26
  • 27
1
vote
2 answers

A query to get the MAX LEN of every field in a SQL table

I've been trying to come up with a query that will list the name of every column in a table with it's max length. This is in SQL Server 2012. Any help is greatly appreciated.
user3329160
  • 165
  • 2
  • 13
1
vote
1 answer

SQL query faster on slower machine

We have two MS SQL servers running MS SQL 2012. One has 8GB RAM, 2 processors and enough storage. The other has 8 processors, 64GB RAM, multiple attached drives with data, programs, logs and tempdb separated. Usually, the big server is faster on…
RCBeck
  • 11
  • 2
1
vote
1 answer

Terminology for Intermediate to Advance SQL

I've found that I need to use T-SQL quite frequently (and sometime inventively) at work and I'm trying to take my T-SQL skills to the next level. I've seen some queries (such as the ones in the stored procedure mentioned here) which allow you to…
jameselmore
  • 442
  • 9
  • 20
1
vote
1 answer

Openquery alternatives? IT won't enable Openquery on new server

Is anyone aware of alternative methods of querying against Access/DB2 tables as a user in SQL Management Studio without using the Openquery syntax? My department's SQL Server is being upgraded from 2005 to 2012, and in the process, IT has stated…
DangerWallace
  • 11
  • 3
1
vote
0 answers

How do I know a query plan is invalidated?

I'm executing EXEC sp_recompile but I still see query plan cached for this table: SELECT CP.[objtype] , CP.[cacheobjtype] , CP.[size_in_bytes] , CP.[refcounts] , CP.[usecounts] ,…
user3104183
  • 408
  • 1
  • 9
  • 26
1
vote
1 answer

Hive query taking a lot of time just to launch map-reduce jobs

We are using Hive for Ad-hoc querying and have a Hive table which is partitioned on two fields (date,id). Now for each date there are around 1400 ids so on a single day around that many partitions are added. The actual data is residing in s3. Now…
Sreenath Kamath
  • 663
  • 1
  • 7
  • 17
0
votes
1 answer

Clean up the "adhoc plan cache" in SQL Server 2005

I found that the "adhoc cache plan" in my SQL Server 2005 occupies more than 1000MB memory. There is a solution on SQL Server 2008 that could solve the adhoc plan by setting the "optimize the adhoc", but it does not exists in SQL Server 2005? Have…
Vance
  • 386
  • 1
  • 6
  • 15
0
votes
0 answers

How to use the OPENROWSET without setting Ad Hoc Distributed Queries to true?

I’ve been trying to use OPENROWSET function in SQL to upload data from an Excel file to SQL Server. According to my research, Ad Hoc Distributed Queries must be set to true. Unfortunately, I cannot modify the Server Configuration due to security…
Wonwoo Jeon
  • 1
0
votes
1 answer

Updating table metadata on the fly

We put a unique identifier in the extended properties of each table, which is then read by some reports. I'd like to be able to do this on the fly, so we don't have to type it in by hand. However, SQL Server 2008 does not allow ad hoc updates to…
divided
  • 1,249
  • 5
  • 14
  • 27
0
votes
1 answer

Stored procedure with table value parameter but ad-hoc?

I have a stored procedure like this: CREATE PROCEDURE [dbo].[GetInventoryData] @supplierId UNIQUEIDENTIFIER, @numbers dbo.ListNumbers READONLY, @locations dbo.ListLocations READONLY AS BEGIN SET NOCOUNT ON; SELECT…
minhhungit
  • 180
  • 4
  • 25
0
votes
0 answers

Different ways to create ad-hoc analysis on top of S3

I have a data lake in AWS S3. The format of data is Parquet. Daily workload is ~70G. I want to build some ad-hoc analytics on top of that data. To do that I see 2 options: Use AWS Athena to request data via HiveQL to get data via AWS Glue (Data…
Finkelson
  • 2,921
  • 4
  • 31
  • 49
0
votes
2 answers

Enable Data Profiling on Apache Airflow

Data profiling although present in documentation is not visible in a fresh installation. Is there a way to enable it, or it has been deprecated? Installed version is apache-airflow==1.10.3 in case it helps.
Dimitrios Mistriotis
  • 2,626
  • 3
  • 28
  • 45
0
votes
1 answer

BIRT Report Ad Hoc Queries

When users create an Ad Hoc BIRT report and download it to an Excel spreadsheet the default is 40 rows/sheet. I want the default to be 0, which means that it will download all the rows to 1 sheet. I know that the solution is setPageBreakInterval(0),…
anegin
  • 1
1
2
3